Problem with generate rows tool when creating new field (fine for update field)

[ck2019]

Hi

I have a file with some duplicate dates contained so I was going to use the generate row field to create a new field and then remove duplicates based on the new field that's been created.

I've created a workflow and replicated it based on update field option and create new field option

The update field works fine

However, the create new field shows:

Error: Generate Rows (8): DateTimeAdd(9999-12-31, 1, Days) goes outside the supported range of dates

I thought it might be the date format but even when i tried to parse it into a %y-%m-%d it still didn't work so I am hoping someone can explain where i am going wrong?

I've packaged the workflow and sample file together.

Thanks

[LukeM · Accepted solution]

Hi @ck2019 ,

Your Condition Expression needs to refer to the new field you're creating - i.e. [date]<=[UK departure date].

Hope this solves your problem.

Luke

[ck2019]

Perfect - thanks Luke. I thought it must be something easy!