โ08-18-2020 12:26 PM
Hi, I have a problem with the Date.parse () function.
I cannot convert a String to date, the format of my string is the following: โdd/MM/yyyyโ.
It only happens to me with some specific dates (with most data I have no problem).
The problem occurs with the following examples:
Date.parse (โ01/04/1932โ, โdd/MM/yyyyโ)
Date.parse (โ05/02/1939โ, โdd/MM/yyyyโ)
Date.parse (โ09/12/1940โ, โdd/MM/yyyyโ)
Date.parse (โ16/12/1943โ, โdd/MM/yyyyโ)
Date.parse (โ12/02/1950โ, โdd/MM/yyyyโ)
And I always get a NaN as a result of the function.
Thank you.
โ08-18-2020 01:24 PM
Victor,
I can understand how 16/12/1943 would fail. But I tested 1932, 1940 and 1950 and had no issues
This in the mapper expression
Date.parse (โ09/12/1940โ,โdd/MM/yyyyโ)
this is the result
_snaptype_datetime: โ1940-12-09T00:00:00.000 UTCโ
please try again
โ08-18-2020 02:52 PM
Hi @rdill,
I have quite similar problem while using Date.parse() function. (Sound to me that started after the new release)
I have a mapper and an input value that Iโm trying to parse using Date.parse(). On the dynamic preview it is showing the correct output but when on the real output it is writing NaN instead of the date value.
Dynamic preview:
JSON output of the same snap (same field):
โ08-18-2020 03:26 PM
Hi.
I just tried again and got the following results.
โ08-18-2020 08:55 PM
@VictorC Iโve tried the same expressions and am not seeing the same thing.
What are the other settings in the Snap?
Is this validating on a Cloudplex or a Groundplex? Which version is the Snaplex on?