How to get original date from days past

[Madzy]

Example:

Today is August 28 2023 and something been on hold for 54 days we want to get the original date from that past 54 days

08/28/2023 - 54 DAYS = 07/05/2023 (I want this answer)

If someone knows how that would be great!

[jordanmount6]

Hi there. Try this formula datetimeadd([Field1],-54,'days'). Field1 is whatever field the date it coming from. 

[PhilipMannering · Accepted solution]

I don't know what you have in your data... but something like this should work,

DateTimeFormat(DateTimeAdd(DateTimeToday(), -[Days on Hold], 'days'), '%m/%d/%Y')

[Madzy]

Sorry I was specific the days varies the 54 was just an example.

[jordanmount6]

You can add a text box to an action tool to the formula tool and when you run it as an analytically app you can put in the days that you want to subtract or add