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!
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')
Hi there. Try this formula datetimeadd([Field1],-54,'days'). Field1 is whatever field the date it coming from.
Sorry I was specific the days varies the 54 was just an example.
