DateTimeAdd function

[TabsheerMohamed]

I was trying to work on a custom date which was created by one of my colleagues, the formula looks something like this: DateTimeAdd(DateTimeToday(),-1,'day'),

which shows the yesterday's date, everyday it will take previous 1 day date. But I wanted to get something which gives me a year date for my analysis. I tried changing the parameter, nothing works, let's say I am using DateTimeAdd(DateTimeToday(), -12,'month') - it gives 18th of Jan 2022 that's it, instead I want the dates starting from Jan 18th, 2022, to until today.

Can someone please help me with this issue.

[BS_THE_ANALYST · Accepted solution]

See attached workflow. I think it's doing what you want?

[Felipe_Ribeir0 · Accepted solution]

Hi @TabsheerMohamed 

You can use the generate rows tool to do it

[TabsheerMohamed]

THANK YOU SO MUCH :) IT WORKS REALLY WELL

[BS_THE_ANALYST]

@Felipe_Ribeir0 It didn't occur to me that the Generate Rows tool has an optional input anchor. Your method is much more elegant.

[Shoujain]

My solution