Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

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
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Is Access importing the field as a date or as text?

You do not use an input mask to display data, you use a format.  Input masks are for entering data.

Dale
Avatar of 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
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.
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks to all guys...always a big help !!