M mcin7535 Jan 30, 2009 #1 How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query?
How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query?
S Stefan Hoffmann Jan 30, 2009 #2 hi, How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query? Click to expand... You can't format it. But you can build it: DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7,2)) mfG --> stefan <--
hi, How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query? Click to expand... You can't format it. But you can build it: DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7,2)) mfG --> stefan <--
D Douglas J. Steele Jan 30, 2009 #3 Stefan Hoffmann said: hi, How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query? Click to expand... You can't format it. But you can build it: DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7,2)) Click to expand... Or CDate(Format([Field1], "####\-##\-##"))
Stefan Hoffmann said: hi, How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query? Click to expand... You can't format it. But you can build it: DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7,2)) Click to expand... Or CDate(Format([Field1], "####\-##\-##"))
M mcin7535 Jan 30, 2009 #4 How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query? Click to expand... Ok, the build option worked! Thanks for the help!
How can I format a number field in a table that has the data formated like yyyymmdd into a date field using a query? Click to expand... Ok, the build option worked! Thanks for the help!
