Add 1 day to date formula
Hello, I need help with writing a formula to add a day to a date formula. If([RX Trigger]<[RX Ready Date] add 1 day to the RX Trigger date to be the new RX Ready date. Ex: RX Trigger 10/30/2024 and...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this (if I understand your question.) This will not change either the
[RX Trigger] or [RX Ready Date] fields, it's just a different field's calculation.
If([RX Trigger] < [RX Ready Date], [RX Trigger] + Days(1), [RX Trigger])