In a query I am using a date field with the following format 07.11.2002 - I want to convert this to week e.g. 45.2002. Is this possible, and what functions are useful ?
Regards
Luhrern
I have a ODBC connection o an Oracle database with where a field in a table is defined as TEXT. The format used in the field is "blank" spaces followed by number e.g.
" 10987". I want to take these data and export them to an Access table, but in the export process to...
I have a database where dates is pesented by a 8 position text string i.e. 20020726. What kind (if any) of conversion function in Access can I use to convert this to a date i.e from 20020726 (8 position date format) to 2002.07.26 ?
Regards
Luhrern
I have a database where dates is pesented by a 8 position text string i.e. 20020726. What kind (if any) of conversion function in Access can I use to convert this to a date i.e from 20020726 (8 position date format) to 2002.07.26 ?
Regards
Luhrern
I have a database where dates is pesented by a 8 position text string i.e. 20020726. What kind (if any) of conversion function in Access can I use to convert this to a date i.e from 20020726 (8 position date format) to 2002.07.26 ?
Regards
Luhrern
I have a database where dates is pesented by a 8 position text string i.e. 20020726. What kind (if any) of conversion function in Access can I use to convert this to a date i.e from 20020726 (8 position date format) to 2002.07.26 ?
Regards
Luhrern
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.