zeroDate returning 12/31/1969

CloverDX Platform
1

Hi,
I’m trying to use the function zeroDate(), which returns 1.1.1970. I’m using it in a Reformat object, then passing it into the metadata as a data field. When I inspect the data being passed into the metadata, it reads 12.31.1969.

Do you know what could be causing this? The timezone and Locale is set correctly. Could it be a daylight savings time problem?
When I use the today() function, with the same timezone/locale, it returns the correct date and time.

2

Hi hewills,

The reason the date value is outputting 12/31/1969 is that zeroDate() is GMT locale. The data being outputted is represented based on the settings in your metadata. I would recommend changing the locale in your metadata to UTC.

3

Ah, can’t believe I missed that! Thanks, that worked great.