


Can'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.
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.
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.