SystemDateToLocalDate Function

The SystemDateToSystemDate function converts the date to local time. Similar functions include LocalDateToSystemDate and the Now function.

The SystemDateToSystemDate function can be used in conjunction with the DateAdd function or the DateDiff function or other Date/Time functions.



1 = Date/Time value to convert




var @now
set @now = Now()
set @LocalDateToSystemDate = LocalDateToSystemDate(@now)
set @SystemDateToLocalDate = SystemDateToLocalDate(@now)

Now: %%=v(@now)=%%
LocalDateToSystemDate: %%=v(@LocalDateToSystemDate)=%%
SystemDateToLocalDate: %%=v(@SystemDateToLocalDate)=%%


Now: 2/15/2021 11:04:46 PM 
LocalDateToSystemDate: 2/15/2021 10:04:46 PM 
SystemDateToLocalDate: 2/16/2021 12:04:46 AM


See the differences in time between the Now function, the LocalDateToSystemDate function and the SystemDateToLocalDate function. LocalDateToSystem date takes the date/time value of “2/15/2021 11:04:46 PM” and subtracts and hour, where as SystemDateToLocalDate adds an hour.

Leave a Reply

Your email address will not be published. Required fields are marked *