Financial Year to Date 1

[DonnaB]

I'm trying to write a formula to calculate if a date is in the range of FYTD.
Could someone help by pointing me in the write direction? I also need to use this formula to calculate if a date is in the range of FYTD this time last year.
Thanks...

 

[kenhamady]

There is no automatic function, but you can write a formula to calculate your fiscal year, what is your fiscal year? July to June? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[DonnaB]

Yes, our finacial year is from July through to June the following year.

 

[kenhamady]

First create a formula to calculate the beginning date of your fiscal year:

{@FYStart}
if Month (CurrentDate) >= 7
then Date (Year(CurrentDate), 7, 1)
else Date (Year(CurrentDate) - 1, 7, 1)

Now you can use the following boolean to see if a date is in FYTD:

{Date} in {@FYStart} to CurrentDate Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)