date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sten Melin - 02 Aug 2006 10:24 GMT

im sorry for my ignorance but i need help with i suppose a quite simple
problem.

i got two imported text fields.
These two text fields got date informtion presented in yyyymmdd ie 20060802
(the shortdate in my zone is yyyy-mm-dd)

I understand i need to change the format to Date/Time before calculating the
datediff. I cant use the shortdate and therefore been trying to use the
format yyyymmdd but cant get it to work.

could someone please help me ?

Reply to this Message

Douglas J. Steele - 02 Aug 2006 12:14 GMT

To change a text field in yyyymmdd format to a date field, try:

CDate(Format(TextDate, "0000\-00\-00"))

That format statement will convert the text to yyyy-mm-dd, which CDate can
then recognize.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> im sorry for my ignorance but i need help with i suppose a quite simple
> problem.
[quoted text clipped - 10 lines]
>
> could someone please help me ?

Reply to this Message

Sten Melin - 06 Aug 2006 10:11 GMT

Thanks Douglas, thanks a lot for your time.

"Douglas J. Steele" skrev:

> To change a text field in yyyymmdd format to a date field, try:
>
[quoted text clipped - 17 lines]
> >
> > could someone please help me ?

Reply to this Message