Read a bit further mike....
If you are loading it into a table, you are getting implicit conversions... Not advicable...
Analyzing the data you get and normalizing it, like you did is indeed good practice! Job well done I would say !
Does anyone know why this date format is used. (1 Viewer)
- Thread starter Mike375
- Start date
Read a bit further mike....
If you are loading it into a table, you are getting implicit conversions... Not advicable...
Analyzing the data you get and normalizing it, like you did is indeed good practice! Job well done I would say !
FixDOB: CDate(Right([Field4],2) & "" & "/" & "" & Mid([Field4],5,2) & "" & "/" & "" & Left([Field4],4)) Sorry
FixDOB1: CDate(Right([Field4],2) & "/" & Mid([Field4],5,2) & "/" & Left([Field4],4))
I see what you mean. It made the dates in both fields jump to the right alignment
FixDOB1: CDate(Right([Field4],2) & "/" & Mid([Field4],5,2) & "/" & Left([Field4],4))
I see what you mean. It made the dates in both fields jump to the right alignment
GRMBL ... NO NO NO... NO NO NO .... NO NO NO NOOOOOOOOOOOOOOOOOOOO
Flipping CDate!!!!! Dont use CDate!!!! Dateserial!
Or if you feel like you must use CDate... atleast use ISO date to ensure you always get the right date.
Flipping CDate!!!!! Dont use CDate!!!! Dateserial!
Or if you feel like you must use CDate... atleast use ISO date to ensure you always get the right date.
If the date, that is from the Right/Mid/Left is simply appended to a date field I assume it has ""to be a date" to append across. Is the problem one whereby some of the records from the Right/Mid/Left will not be a date and thus not append across and with SetWarnings No you would see it?
Syntax for dateserial is: DateSerial(Year, Month, Day)
The ISO date format you need to use for it to work YYYY/MM/DD or YYYY-MM-DD
If some of the records do not comply and compile to a proper date you will get a popup yes....
The ISO date format you need to use for it to work YYYY/MM/DD or YYYY-MM-DD
If some of the records do not comply and compile to a proper date you will get a popup yes....
No wonder my DateSerial caused an Access melt down.
I am going to post a question in General. I have been playing with something today and while we have been posting, however, I think it might be impossible. Perhaps you can have a look for me.
I am going to post a question in General. I have been playing with something today and while we have been posting, however, I think it might be impossible. Perhaps you can have a look for me.
Hope so or a workaround will do.
