Forum Discussion

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

Format DateTime.LocalNow()

Hello, 

I have a dataflow and i need to include the last refresh date in that dataflow. 

I created a new blank query and entered the following code : 

DateTime.LocalNow()
 
This correclty returns me the date time now. 
 
However, the users who will be using this dataflow are all based in the united states. 
 
How can i format this 
DateTime.LocalNow() to show as mm/dd/yyy hh:mm:ss 
Or, just to show as 14th Febuary 2024 10:01:22
 
Thanks 
Need Help
  • katemarkoska's avatar
    katemarkoska
    2 years ago

    Hi PPStar 
    You do not need to format anything. This function returns a datetime value set to the current date and time on the system.
    So if the users are in the US and the region on their system is set to US it will automatically format as mm/dd/yyy hh:mm:ss.

3 Replies