Formatting Dates

[paulS30berks]

I wondered if someone could point me in the right direction.

I am pulling dates from a table in the format:

7092000
11092000

How can I reformat to:

07/09/2000
11/09/2000

Thanks

Paul

 

[KenHigg]

Have you considered the options available with the format() function?

 

[paulS30berks]

Thanks for your reply.

The data field is numeric, so I am unable to lookup date formats.

I have written the statement:

Start: DateValue(Mid([Start_Date],7,2) & "/" & Mid([Start_Date],5,2) & "/" & Mid([Start_Date],1,4))

although I think this formats original data type: 20000119 to 19/01/2000.

thanks

 

[KenHigg]

I don't suppose you could convert it to a variant data type first?

 

[paulS30berks]

Unfortunatley not - as Permissions are with IT (powers that be).

Is there anyway to reformat without amending data field in table?

 

[KenHigg]

Have you simply tried to use the CDate() function?
So how are you getting your date data?

Like this:
7092000
11092000

Or like this:
20000119

???

 

[paulS30berks]

Data is in format 11092000

 

[KenHigg]

Then I would think that something like the following would work:

Format(CDate([Start_Date]), "mm/dd/yyyy")

 

[paulS30berks]

An #Error is shown for all records

 

[KenHigg]

Can you post a .mdb with some sample data in it?

 

[comptechbranden]

I am using 97...Is there a code for an autodate for the current date. Is it changable in the form if needed? Thanks.