Power-Fx
Power-Fx copied to clipboard
Text(DateValue(Today()), "") Doesn't Return Today's Date in Unix Time
Hi! Cards team has been running into issues when executing Text(DateValue(Today()), "") expression in Cards.
The same expression returns Today's date in Unix time in Canvas:
whereas an empty string ("") gets returned in Cards:
Any insights or guidance on this issue would be greatly appreciated. Thanks a lot for your time and help in advance!
This expression should give you the wanted result:
Round((Now() - DateTime(1970,1,1, 0,0,0) ) * 86400000, 0)
You can replace Now() with another datetime value.