I have a date field in sql, but when we import the date it is formatted as month and year.
I need to automatically add the last day of the month to the date for example:
if the date is imported as 022013 I need it to automatically change to 02282013
then concatenate the field as a date time field.
I will have to set this up for every month.
Thank you so much.