DeveloperMar
Programmer
How can I change the 1st day of the year to 6/26/00, and change the 1st day of the week to Monday? I need to report data based on the Company's fiscal calendar.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
change calendar to fiscal year
- Thread starter DeveloperMar
- Start date
- Status
WaltLukeIII
Programmer
I am not sure what your question really is but If you want to get information that has been added since a certain date Run a Select Query. with every date greater (>
than 6/26/00 and that will give you a certain year of data if you want to know from past years from 6/26/97 - 6/26/98 then use the between 6/26/97 and 6/26/98 and that will give you a year's worth of data then if you want from a monday to a monday do another query off one of these. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=
than 6/26/00 and that will give you a certain year of data if you want to know from past years from 6/26/97 - 6/26/98 then use the between 6/26/97 and 6/26/98 and that will give you a year's worth of data then if you want from a monday to a monday do another query off one of these. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question