Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Crystal Report formula help to define current fiscal month and year

Avatar of kelsanit
kelsanit asked on
Crystal Reports
6 Comments1 Solution1783 ViewsLast Modified:
I have two tables "Orderlinemaster" & "Fiscal periods".  They are joind by two field called fiscalyear and fiscalmonth.  The fiscal periods table has the following fields (Month, year, fiscalmonth, fiscalyear, begindate, enddate, shippingdays)

My question is this - based on the "Currentdate" I need a formula that will display what the current fiscalmonth is.  

For example: if today is 2/25/2009 the it would display fiscalyear = 2009 fiscalmonth = 12

The fields in the fiscalperiods talbe are defined below to help out:
Month:  Calendar month of fiscal month
Year: calendar year of fiscal month
Fiscalmonth: fiscal month number
Fiscalyear: fiscal year number
Begindate: start date of fiscal month
enddate: enddate of fiscal month
shippingdays: number of shipping days in that fiscal month

Example to go along with above date sample output.
Month:  3
Year: 2009
Fiscalmonth: 12
Fiscalyear: 2009
Begindate: 2/22/2009
enddate: 3/28/2009
shippingdays: 25

Avatar of peter57r
peter57rFlag of United Kingdom of Great Britain and Northern Ireland image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers