Hello Community,
I hope everyone is well.
I have a year's worth of data that I need to formulate a return of every seven days from an specific day in the past.
I am trying the formula below, but it is not working...there are no errors, but it is not separating as expected.
DATETIMEPARSE([captured_date], "%Y-%m-%d") >= DATETIMEADD(DATETIMENOW(), -7, "days")
Thank you,
Fausto
Hi @Fescobar
The formula that you have there will return true or false. What exactly are you looking to do? It's not clear to me based on the attachment. If you provide some more info on inputs and expected output I'm sure there's a solution.
If you're looking for every 7th day then might be as simple as filtering:
DateTimeFormat([captured_date],"%A") = DateTimeFormat(DateTimeNow(),"%A")
So if captured date was a Wednesday it would grab every Wednesday which would get every 7th day.
Thank you for replying .@luke_c!
The file has a few highlighted cells on the date column. Those days are all Thursdays going back one year to date (I attached a small sample), these are the dates that I would need returned.
I hope that this clears it up.
Thanks again!
Fausto