Example 1:=currentdate("America/Chicago", "The day of the week is %A") = The day of the week is TuesdayExample 2:=currentdate() = 2021-05-04UTC
Example 1:=currentdate("America/Chicago", "The day of the week is %A") = The day of the week is TuesdayExample 2:=currentdate() = 2021-05-06 02:01:49.317275816Example 3:=currentdatetime("America/Chicago", "%Y %m %d %H:%M:%S") = 2021 05 25 17:58:25
Example 1:=currenttime() = 14:26:36Example 2:=currenttime("America/Chicago", "%H:%M:%S") = 02:01:49
Example 1:=date(quot;DOB") = 1982-06-03Example 2:=date(quot;Birthdays", "%m/%d/%C", "%Y-%m-%d") = 1982-06-03Example 3:=date(quot;PurchaseDate", ,"%m/%d/%Y") = 06/22/2020
Example 1:=datetime("10/20/2020 10:22 PM") = 2020-10-20 22:22:00Example 2:=datetime(currentdatetime(),,"%Y-%m-%d %H:%M:%S") = 2021-04-06 14:19:16
Example 1:=time("10/20/2020 10:22 PM") = 22:22:00Example 2:= time(quot;Time of Purchase")=03:16:09Example 3:=time(concat(quot;hours",":", quot;minutes",":", quot;seconds"))= 09:33:18