Add 1 day to date formula

Question

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 RX Date 10/29/2024. Result needs to be RX Ready Date 10/31/2024.

Thank you

Kathy Benjamin

markshnier__you · Answer

Try 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])

Forum Discussion