LocalDateToSystemDate Function

The LocalDateToSystemDate function converts the date to system time. Similar functions include SystemDateToLocalDate and the Now function.

The LocalDateToSystemData 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 funtion, 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 *