Dates - Trying to compare

Ask a question
1

Hi All,

I am trying to pull back data and do something if a today’s date is 7 days before a date already in the dataset.
I have tried Compare date so I could then filter on 7, but I get so many weird numbers and an warning saying: One or more of your date columns is not in a valid format and therefore did not receive a result.
I formatted the columns to be dates within Parabola!!!

Any help/guidance, much appreciated.

2

Hi @Tony_Standing - Can you try formatting the date columns to YYYY-MM-DD and then use the Compare Dates step? Let me know if you still encounter an error with that.

If that works, you can always reformat the dates after that to get it into your desired format. Let me know how that goes!