cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
karimk Regular Visitor
Regular Visitor

DateTime.LocalNow() = Wrong Date

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

1 ACCEPTED SOLUTION

Accepted Solutions
SonnyChilds Established Member
Established Member

Re: DateTime.LocalNow() = Wrong Date

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:

image.png

2 REPLIES 2
SonnyChilds Established Member
Established Member

Re: DateTime.LocalNow() = Wrong Date

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:

image.png

karimk Regular Visitor
Regular Visitor

Re: DateTime.LocalNow() = Wrong Date

Hi @SonnyChilds

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

Thank you.