Creating a query that will return specific days-3
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined calendar year as the 2nd Tuesday in January and fiscal year as the 4th Tuesday in June. Please help!
Software/Hardware used:
Software/Hardware used:
ASKED:
September 1, 2004 10:20 AM
UPDATED:
September 2, 2004 10:21 AM
Answer Wiki:
Hi,
See http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-14-udf_DT_NthDayInMon.htm
for a Nth day in month UDF.
Regards,
Andy
Novick Software
http://www.NovickSoftware.com
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
