How to Return Current Date and Time in Power Query

We use DateTime.LocalNow() to return the current datetime in datetime format. Then we encompass that in either DateTime.Date() or DateTime.Time if we want to narrow it down to just the date or just the time.

[fredbaden]

Thanks, how would you add the creation date from the file meta data? I was asking some AI tools to support but I can’t get there

[anabertha]

Thanks for the short but very useful tip!!

[dwarfusinterruptus]

How do you do this so that it is a fixed date and time stamp (I don't want it to recalculate every time a file is refreshed)?