Hello,
Been staring at this simple workflow, trying to fix it, for too long. I'm sure it's very simple what I'm missing.
Looking to add an End Date column where it is null if the next row is a consecutive date for that person, otherwise it is just the time off request date. Basically, trying to create a calendar entry using start/end dates for one solid window when they are consecutive dates.
Here's the expression I tried and for some reason it will not set the 2 values equal to each other even though I know they are:
IF DateTimeAdd([Row+1:TIME OFF REQUEST DATE],-1,"days") =[TIME OFF REQUEST DATE] THEN '2099-01-01' ELSE [TIME OFF REQUEST DATE] ENDIF
I actually just want the THEN part null but I thought maybe it needed a date instead, nothing was working.
Thanks in advance for your help, I just love the community!
Solved! Go to Solution.
Thank you so much! I thought I was going crazy, date format looks to be really tricky indeed.