S Sunny Dec 7, 2004 #1 I need to convert my date in yyyymmdd format. e.g, '20041207'. What is the easiest way to get it? Thanks.
I need to convert my date in yyyymmdd format. e.g, '20041207'. What is the easiest way to get it? Thanks.
K Ken Snell [MVP] Dec 7, 2004 #2 Convert it from what to this? And where -- as stored in a table (must be a string if you want to store it exactly as yyyymdd), which note that a date/time field stores date as a double-precision number, not as the date string? in a query? You don't give us much info here....
Convert it from what to this? And where -- as stored in a table (must be a string if you want to store it exactly as yyyymdd), which note that a date/time field stores date as a double-precision number, not as the date string? in a query? You don't give us much info here....
