Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

AddHours help

Avatar

Level 5

0694X00000AsiYSQAZ.pngCan't get this date to subtract 14 days. Have added and removed extra colons, tried reformatting the date, nothing works. It's probably something simple or right under my nose.

1 Reply

Avatar

Level 4

Hi Howard, I can't really tell from your screenshot. But here is how I would troubleshoot this:

Confirm what is coming out of that particular field without any manipulation by removing the "addDays" completely.

  • based upon what value is, determine whether it is actually a date. If it is really a date ...it would show in a UTC format. You could also hover over the column in the mapper to determine the data type (text or date).

I suspect the data is literally blank or not actually a date. If it is not actually a date, then you'll need to use parseDate to get it to an actual date. Depending on the format you see when you look at the date, itself.