Is there a way to extract the year and month only from a date field and create a new field?
I have tried DatePart("yyyymm", [DischDate]) and multiple little versions of that and I can't seem to get anything to work.
I tried to do the year and month separately and then concatentate them together and then it drops off the leading 0.
I want the final result to be for example 201207
Thank you.
I have tried DatePart("yyyymm", [DischDate]) and multiple little versions of that and I can't seem to get anything to work.
I tried to do the year and month separately and then concatentate them together and then it drops off the leading 0.
I want the final result to be for example 201207
Thank you.