DateTime.LocalNow() = Wrong Date

[karimk]

Hi,

I´m trying to create a card with the dataset refresh date that will work correctly with my desktop file and the report server, but among many solutions I always see the use of the DateTime.LocalNow() formula. It outputs the correct time, but a wrong date (03/07/2018). Any idea on why is this?

Thanks

[Anonymous · Accepted solution]

That's outputting a day/month/year format; how are you reading the data? The actual data it returns can be shown in day/month/year or month/day/year format, or however you prefer in the frontend.

Check the actual output in the query editor:

[karimk]

Hi @Anonymous

I´m sorry. It was that obvious. I was thinking of March 7th.

Thank you.