Expression in mapper
how to write below expression in snaplogic
least(
IIF(ISNULL(LINEAR_PREMR_DATE),to_Date(‘01/01/4000’,‘mm/dd/yyyy’),LINEAR_PREMR_DATE),
IIF(ISNULL(GO_PREMR_DATE),to_Date(‘01/01/4000’,‘mm/dd/yyyy...
Forum Discussion
Using Date.parse() on a date-only value will set a datetime value to midnight UTC for that date (ex. 2022-10-03T00:00:00.000 UTC). By changing the time zone to New York time, you are effectively changing it to UTC-05:00 (or -04:00 for daylight saving time), so the date-only value will show one day earlier. If you need to keep the exact date value, then you can leave out the timeZone key/value entirely.
Date.parse($DATE_ELECTED).toLocaleDateTimeString({"format":"MM-dd-yyyy"})
That worked to bring in the correct date and format. On the next field, I need to add 31 days to the $DATE_ELECTED. If that date is <= today, it should be “true” --if not then false.
This syntax worked except the code does not that local date string and if the date occurred today, it would be true. I have tried a couple of things but cannot get the syntax just right to reflect that issue. Here is what was almost working perfectly before:
Date.parse($DATE_ELECTED).plusDays(31)<=Date.now()
Can you help it to recognize the local date so that the $DATE_ELECTED field is correct?
@heidi.andrew
Regarding your date time follow-up question:
There may be a dozen ways to reformat the syntax to achieve what you want, but this is the first thought to come to my mind (if I’m following your requirements right), which may not be the most optimized syntax option:Date.parse($DATE_ELECTED).plusDays(31) <= Date.parse(Date.now().toLocaleDateTimeString({"timeZone":"America/New_York"}))(obviously, if I misunderstood the requirement, this will not be helpful)
Regarding your second question around Match/Contains, I believe @bojanvelevski just now answered that question for you at How to use "contains" function in router? I am getting error of expression failure - #9 by bojanvelevski while I was responding to your datetime question.
This worked perfectly. Thanks for your help.
adds 31 days to current date
Date.parse($DATE_ELECTED).plusDays(31).toLocaleDateTimeString({“format”:“MM-dd-yyyy”})logic for date math:
Date.parse($DATE_ELECTED).plusDays(31) <= Date.parse(Date.now().toLocaleDateTimeString({“timeZone”:“America/New_York”}))
