Format DateTime.LocalNow()

[PPStar]

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 

[katemarkoska · Accepted solution]

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.

[PPStar]

Thanks Kate. I just tested this and you are correct. Thank you. 

[Idrissshatila]

Hello @PPStar ,

check this video https://youtu.be/eH9dHfNG8kg?si=lWwD8RbJhb7Dxnv2