asked on Crystal reports: Paramater for selecting current and last quarter dates
Hello Experts,
I am trying to build a formula to be used in selection parameter to select the END of the "CurrentQuarter" and the "LastQuarter". Here is what I have so far, it works fine to select the begining date , just need the last date of the quarter.
Current Formula:
else if (rptPeriod = "CURRENTQUARTER") Then
bdt := Date(Year( Today),Month(DateAdd('m', -(Month(Today) Mod 3 + 2) mod 3, Today)),01)
else if (rptPeriod = "LASTQUARTER") Then
bdt := Date(Year(DateAdd('m', (-(((Month(Today) Mod 3) + 2) mod 3)-3), Today)),Month(DateAdd('m',
bdt;
I am trying to build a formula to be used in selection parameter to select the END of the "CurrentQuarter" and the "LastQuarter". Here is what I have so far, it works fine to select the begining date , just need the last date of the quarter.
Current Formula:
else if (rptPeriod = "CURRENTQUARTER") Then
bdt := Date(Year( Today),Month(DateAdd('m', -(Month(Today) Mod 3 + 2) mod 3, Today)),01)
else if (rptPeriod = "LASTQUARTER") Then
bdt := Date(Year(DateAdd('m', (-(((Month(Today) Mod 3) + 2) mod 3)-3), Today)),Month(DateAdd('m',
bdt;
Crystal Reports
Last Comment
Maliki Hassani
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!