writing a select expert based on a fiscal year using crystal 2011 1

[jchewsmith]

Our fiscal year starts 7/1 and ends 6/30. How can I select records based on Fiscal year to date?

so today I want all records from 7/1/2017 to current but on July 15, 2018 I will want all records from 7/1/18 to current?

 

[lbass]

Assuming your fiscal year is identified by the ending year, create a formula like this:

//{@fyr}:
Year(currentdate+184)

Then use a selection formula like this:

{table.date} >= date({@fyr}-1,7,1) and
{table.date} < currentdate+1

-LB