Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
2 months ago

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...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    2 months ago

    IF([REPORT: RX Type Description]="RX With Benefit Changes"

    and

    [REPORT: Rx Trigger Date] > [Report: RX Ready Date], [REPORT: Rx Trigger Date] + Days(1), [Report: RX Ready Date])

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
2 months ago

This formula worked.  I am now being asked to add to the formula:  RX Type = RX with Benefit Changes.  I tried with this and it did not work.  Any suggestions?

If([REPORT: RX Type Description]="RX With Benefit Changes",and [REPORT: Rx Trigger Date] > [Report: RX Ready Date], [REPORT: Rx Trigger Date] + Days(1), [Report: RX Ready Date])