Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Getting Previous Day from a populated Date column

Soxfaninfl
8 - Asteroid

I am trying to get the previous date for a column that already has dates in them. The column is called [resolveddate] and it has random dates beginning on 8/1/22 to present. So if a rep closed work on 8/29/22, how to do get the previous day's date of 8/28/22? The reason I'm doing this, some times reps make visits to clients, but don't close the online paper work up to three days later. I need to use this expression when a rep makes a visit on 8/26 and closed the online paper work on 8/29. I need an expression to change the online paper work close date of 8/29 to change it to 8/26 to match the visit date.

1 REPLY 1
Soxfaninfl
8 - Asteroid

I was able to figure it out, so I am good. DateTimeAdd([resolveddate],-1,"days") 

Labels
Top Solution Authors