I want to flag a user whether their follow-up date is either in the current month or previous month or upcoming month based on the today () function. Can anyone give me an insight on how to write this condition?
You can use the format-date() function to extract the numeric month from a date, which you can then use to compare the calendar month between two dates.
If you are instead looking to compare the days between two dates, you can cast a date to an int, generally safest to double-cast just in case, IE: int(date(#yourvalue)), which will convert it to a number of days.
Thank you, Clayton!
I will get back to you in case I need more info!