Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
0
Reply
SQL access fiscal where clause query
David Smith
Sep 2 2012 4:50 AM
857
Reply
Can some write the logic below in a simpler way Using Access SQL query
If Month(Now()) < 7 Then
TempYear = Year(Now()) - 1
Else
TempYear = Year(Now())
End If
FiscalYearStart = "7/1/" & TempYear
FiscalYearEnd = "6/30/" & (TempYear + 1)
StrFilter = StrFilter & "ServiceDateStart >= #" & FiscalYearStart & "# AND ServiceDateStart <= #" & FiscalYearEnd & "#"
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
SQL date where clause
RAID Configurations in SQL