Hi Everyone,

Is there a way to calculate CurrDate - 2 months and display in month format? I wouldn't want to - 60 days because if the current month is April I'd always want to display February.

Thank you!

Solution

Hi

FormatDateTime(AddMonths(CurrDate(),-2),"MMMM")


subtracts 2 months from the current date and then shows only the month name.


Hope it helps




Solution

carl ruhle wrote:

Hi

FormatDateTime(AddMonths(CurrDate(),-2),"MMMM")


subtracts 2 months from the current date and then shows only the month name.


Hope it helps




That really does, thank you so much! I was so ridiculously close that I had every element but just not in the right order. Thank you again!