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!

Register Log in
  • 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

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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chish_nc
  • Locked
  • Question
show annivesary dates for next quarter 1
Replies
3
Views
375
chish_nc
chish_nc
tdrBates
  • Locked
  • Question
Schedule report to run only peak times every day
Replies
2
Views
123
kray4660
kray4660
n2nuk
  • Locked
  • Question
Page footer printing on every page instead of last page
Replies
1
Views
113
kray4660
kray4660
Florenze
  • Locked
  • Question
Crystal Rerort - invoice report per quarter & total per page
Replies
1
Views
94
lbass
lbass
ClowneUser
  • Locked
  • Question
Page header not repeating on every page
Replies
6
Views
191
ClowneUser
ClowneUser

Part and Inventory Search

Sponsor

Back
Top