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.
I was able to figure it out, so I am good. DateTimeAdd([resolveddate],-1,"days")
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |