I have a question about date convert. Currently I have a field that is a date/time and default as short date. now we need to change to just month/year in stead mm/dd/yyyy. I do not want to change anything in th SQL about this data field because we have over hundred thousand records in the table. what I want to do now is put two unbound field in the form, when enter mm & yyyy on these two unbound fields, so I can convert this two unbound field to the data field in the back ground, but I'm having trouble to put the first day of the month to put into the date field.
the Current date field is name "SUTEMDate". I have one unbound field name "SUMM" and another unbound field name "SUYY".
here is my coding on both unbound field after update:
If Not IsNull(SUMM) then
SUTEMDate = SUMM
but it seems not working. What I want to do is if I enter 07 in the SUMM field and 2013 in the SUYY field then the SUTEMDate should show 07/01/2013.