Forum Discussion
Getting Current Time not populating column
Hi, I want to simply get the current date and time when I refresh my dataset, but I am getting no value when I hit refresh on my table with column: DateTime.LocalNow().
And when I pull this column into a card it just shows the "Count of Year"
Any ideas why no date/time is being populated in my column?
Hi Anonymous ,
I had a test on my side:
You may click the refresh button to load data:
Actually I could reproduce your issue by following these steps:
So please firstly click the Card visual and drag the Date & Time field to it, you will get the expected output:
Or you could use NOW() to create a calculated column:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
Anonymous Are you sure you pulled in the right column? Because it looks like you pulled in the "Year" column. Otherwise it should say Count of Date & Time.
Anonymous Can I see a screen shot of the Date & Time column in your Data view? Does it have the actual date and time?
Hi Anonymous ,
I had a test on my side:
You may click the refresh button to load data:
Actually I could reproduce your issue by following these steps:
So please firstly click the Card visual and drag the Date & Time field to it, you will get the expected output:
Or you could use NOW() to create a calculated column:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
