I have several projects where I could use Today() in Dataverse Formula Columns, it would be awesome to be able to get the status of things based on date, directly from the database instead of having the logic in apps, reports and everywhere.
My need is quite similar to this post: Solved: Calculated column to compare date with today date. - Power Platform Community (microsoft.com) - I simply need to be able to compare a stored Date value to Today.
As of now, Today() can't be used and UTCToday() doesn't quite cut it (I could almost get away with using DateAdd to add 3 hours to UTCToday to get our local time, but then there are daylight savings...). I'm actually quite surprised this isn't already possible, since comparing dates is just about the most basic thing you can do with data.
I have not found where to make feature requests to Dataverse - if anyone knows of a place, I would appreciate the information. For now, I'll make one here:
Please add possibility to define TimeZone with Today() in Dataverse Formula Columns, for example Today(TimeZone.Finland) . That would solve a million needs in one go!

Report
All responses (
Answers (