Skip to main content
S
sugasanr300208
October 11, 2021
Question

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

  • October 11, 2021
  • 4 replies
  • 0 views

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

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    October 11, 2021

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

    S
    sugasanr300208Author
    October 11, 2021

    thank you. it works

    H
    hrishikeshd997
    October 11, 2021

    You can use a combination of todatetime() and gmt() in this case.

    gmt(todatetime(today() & " 12:00 AM"), usertimezone(loggedInUser()))

    S
    sugasanr300208Author
    October 11, 2021

    Thank you, this one too works [emoticon:c4563cd7d5574777a71c318021cbbcc8]

    Terms & ConditionsAccessibility statement