hello,
what is the select statement to get 1st and 15th of every month from todays date till the end of current fiscal year (sep 30th)
ex:
June 15th - 06/15/2008
July 1st - 07/01/2008
July 15th - 07/15/2008
-
-
sep 1st - 09/01/2008
sep 15th - 09/15/2008