Generate start date based on end date

[knozawa]

My end date is generated by a formula, DateTimeNow(). I would like to generate start date which is a year ago from today.

I would like to get data with this format: 2016-08-21T00:00:00.

Does anyone know how to approach this?

Thank you,

Kazumi

[JohnJPS · Accepted solution]

You can use DateTimeAdd to add 1 year to DateTimeNow.

[knozawa]

Thank you!