Dynamic year rage in perticular date

[chunbabachun8]

Hi,
I was wandering if anyone can help me out. I want get rid of hard coded date and year instead make this range of date dynamic and by changing the year only.
I assume my (Fiscal Year)
@FY = '2018'
CASE BETWEEN (TDATE,{^2017-07-01},{^2018-06-30}) -- I want to make only Year Dynamic like {TDATE,{^(@YR-1)+(-07-01),{^(@YR)+(-06-30)}
YR = '2018'
CASE BETWEEN (TDATE,{^2016-07-01},{^2017-06-30}) -- {TDATE,{^(@YR-2)+(-07-01),{^(@YR-1)+(-06-30)}
YR = '2017'
CASE BETWEEN (TDATE,{^2015-07-01},{^2016-06-30}) -- {TDATE,{^(@YR-3)+(-07-01),{^(@YR-2)+(-06-30)}
YR = '2016'

I'm new to FoxPro programming and I am helping my company to fix the hardcoded years to dynamic fiscal year ending and beginning.

I mostly work on sql programming.

Really appreciate for quick help!

 

[SkipVought]

Hi,

This is MS Access. Do you need FoxPro help or Access?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[chunbabachun8]

Hi SkipVought,
I need ForPro help!

chunbabachun8

 

[SkipVought]

Forum184

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[chunbabachun8]

Thanks!

chunbabachun8