I need to create a Date Field to return to a VB.Net app based on the current month/year, however the day needs to be the 1st day of the month. Here is what I have and it's not working.
How would I do this? I can't find any examples online.Code:Convert(DateTime, Month(GetDate()) + '/1/' + Year(GetDate()), 101) as DayOne




Reply With Quote