Link to home
Start Free TrialLog in
Avatar of davetough
davetough

asked on

10152012 inputted as date in table- need to format

hello,
i have sample db attached- open database and open table [tbl1]
One field [P/U Date] is not formatted right.

Is there a way to change the date field [P/U Date] to display fo 9/1/2012?

right now the dates display like this: 10152012, 10272012, etc....
thank you-
DateData.accdb
Avatar of jerryb30
jerryb30
Flag of United States of America image

Dateserial(right([p/u Date], 4), left([P/u Date], 2), Mid(p/u Date], 3,2))
SOLUTION
Avatar of IrogSinta
IrogSinta
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
ASKER CERTIFIED SOLUTION
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
Avatar of davetough
davetough

ASKER

I apoligize to get back here late- having problem when date is august or september - like 9152012-
will these codes work for that too?
thank you
thank you