how to create local date and set time as 12:00 AM

Question

Hi All, 
 
 I have to create a local date and set the time as 12:00 Am, For eg, if I am in the CST timezone and today date is 10/11/2021 then the date time should be 10/11/2021 12:00 AM CDT

Stefan Helzle · Accepted Answer

userdatetime(
 year(today()),
 month(today()),
 day(today()),
 12,
 0,
 0
 )

Hrishikesh Dixit · Answer

You can use a combination of todatetime() and gmt() in this case. 
 gmt(todatetime(today() & " 12:00 AM"), usertimezone(loggedInUser()))

sugasanr0001 · Answer

thank you. it works

how to create local date and set time as 12:00 AM

Top Replies