FY Range Determination
From: J.R. Rushmeyer <rushmeyer_at_ada.state.oh.us>
Date: 1998/01/02
Message-ID: <01bd17bd$7e1c8ce0$0b3c3f9c_at_tcp011>#1/1
Date: 1998/01/02
Message-ID: <01bd17bd$7e1c8ce0$0b3c3f9c_at_tcp011>#1/1
Has anyone written a script or procedure determining if the SysDate fell
within a certain FY range?
If the SysDate is greater than July 1, 1998 then the start date if
7/1/1998 (the current SysDate year)
I need to set up a procedure that will run that Query but am not sure how
to do it in SQL. If anyone has done this before (in a Procedure File) any
For example, if the SysDate is less than July 1,1998, then the start date
for the FY is
7/1/97 (the SysDate year less 1)
and the End Date is June 30,98 (the SysDate actual year)
and the End Date is June 30, 1999 (the SysDate year PLUS 1)
Thanks
J.R. Rushmeyer
Ohio Dept of Alc and Drugs
Received on Fri Jan 02 1998 - 00:00:00 CET