Fordraiders
asked on
format of date when importing in
define input mask for imported data:
I have data in a field i'm trying to import in and it looks like this:
2018-10-19 11:59:17
I'm trying this input mask along with General Date as the "Format"
"YYYY-MM-DD";HH:MM:SS
Coming in as
10/19/2018 11:59:17
I tried creating an input mask rule but not working.
fordraiders
I have data in a field i'm trying to import in and it looks like this:
2018-10-19 11:59:17
I'm trying this input mask along with General Date as the "Format"
"YYYY-MM-DD";HH:MM:SS
Coming in as
10/19/2018 11:59:17
I tried creating an input mask rule but not working.
fordraiders
ASKER
dALE, Is Access importing the field as a date or as text? tEXT
OK, so are you then converting it to a date field at some point, using the cDate() function?
When I bring data in from Excel, I always import it into a staging table, and then move it from the staging table into the production table, after examining the data. When I move it from staging to production, I perform the appropriate transformation to get the data into the right data type.
Dale
When I bring data in from Excel, I always import it into a staging table, and then move it from the staging table into the production table, after examining the data. When I move it from staging to production, I perform the appropriate transformation to get the data into the right data type.
Dale
You can also link the Excel data.
Then create a query that does the necessary filtering, aliasing, and converting, here using CDate to convert your text date.
This is very easy to debug and modify until the correct output is achieved.
Now, use this query for the further processing.
Then create a query that does the necessary filtering, aliasing, and converting, here using CDate to convert your text date.
This is very easy to debug and modify until the correct output is achieved.
Now, use this query for the further processing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks to all guys...always a big help !!
You do not use an input mask to display data, you use a format. Input masks are for entering data.
Dale