ISBTECH
asked on
Mid Month Date range in Crystal
Hi all,
How do I do a selection formula that looks for the "ActualClosingDate" to be between the 16th or the prior month to the 15th of the current month?
How do I do a selection formula that looks for the "ActualClosingDate" to be between the 16th or the prior month to the 15th of the current month?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay thanks that worked perfectly!
{ActualClosingDate} >= DATE(YEAR(DATEADD("m", -1, TODAY)), MONTH(DATEADD("m", -1, TODAY)), 16)
AND {ActualClosingDate} <= DATE(YEAR(TODAY), MONTH(TODAY), 15)