Crystal Reports Fiscal Year

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Fiscal Year

Post Reply

Post New Topic

Author	Message
jbalbo Senior Member Joined: 17 Feb 2011 Online Status: Offline Posts: 219	Topic: Fiscal Year Posted: 08 Feb 2013 at 3:56am
	Hi looking for a formula to calculate which fical year a date parameter falls in. Example Paramter = Startdate (user enters 2/1/13) Fiscal year runs july thru june So I wanted two formulas 1. to get me 7/1/12 and 2 6/30/13 (in this example) If they enter 2/1/12 then 7/1/11 - 6/30/12 Thanks Joe
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Feb 2013 at 12:00pm
	you might need to tweak these but I hope they get you started start date dateserial(year(param) - (if month(param)<6 then 1),7,1) end date dateserial(year(param) + (if month(param)>6 then 1),6,30) Edited by DBlank - 11 Feb 2013 at 3:48am
	IP Logged

jbalbo Senior Member Joined: 17 Feb 2011 Online Status: Offline Posts: 219	Posted: 11 Feb 2013 at 9:04am
	Thanks :)
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum