Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Every Quarter

Status
Not open for further replies.

Steve95

MIS
Nov 3, 2004
265
US
Hi All

Iam using CR11, does anyone know the syntax which captures the last quarter's dates, similar to the 'lastfullmonth' syntax.

Thank you
 
If CurrentDate in Calendar1stQuarter
Then {Your.Date} in DateAdd('m',-3,Date(Year(CurrentDate),01,01)) to Date(Year(CurrentDate)-1,12,31)
Else
If CurrentDate in Calendar2ndQuarter
Then {Your.Date} in Calendar1stQuarter
Else
If CurrentDate in Calendar3rdQuarter
etc...

Naith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top