Forum Discussion
JemmaD
Helper V
Helper VDatetime only showing Date and no time
Hi there, I have created a custom 'RefreshDate' column in m query by using =DateTime.Date(DateTime.LocalNow()) I changed the column format to locale datetime format, and it's showing today's date b...
So the issue was my syntax, using DateTime.Date(DateTime.LocalNow()) was forcing the field to be a date only so changing the column type to datetime wasn't making any difference.
I changed my syntax to =DateTime.LocalNow() and it brought in the time!
JemmaDHelper V
Helper VSo the issue was my syntax, using DateTime.Date(DateTime.LocalNow()) was forcing the field to be a date only so changing the column type to datetime wasn't making any difference.
I changed my syntax to =DateTime.LocalNow() and it brought in the time!