Forum Discussion

JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
2 years ago
Solved

Datetime 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 but with hh:mm:ss as 00:00:00

 

How do I display the time as well?

Need Help
  • JemmaD's avatar
    JemmaD
    2 years ago

    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!

2 Replies

  • JemmaD's avatar
    JemmaD
    Icon for Helper V rankHelper V
    2 years ago

    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!