Multi Row Tool - Setting an End Date with Consecutive Dates

[frank6773]

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!

[Qiu · Accepted solution]

@frank6773 
I marked the part I made modifications.

DateTime is tricky, so I forced the format.

[frank6773 · Accepted solution]

Thank you so much!  I thought I was going crazy, date format looks to be really tricky indeed.