backwards date

[neilb]

Hi

Does anyone know if there is an easy way to swop a backward date around?

The date come from a as400 file and looks like

1021107

this would be 07/11/02.

or would i have to do a lookup table.

many thanks

 

[DonkeyOte]

On 2002-11-07 10:23, neilb wrote:
Hi

Does anyone know if there is an easy way to swop a backward date around?

The date come from a as400 file and looks like

1021107

this would be 07/11/02.

or would i have to do a lookup table.

many thanks

assuming date in A1

=RIGHT(A1,2) & "/" & MID(A1,4,2) & "/" & MID(A1,2,2)

_________________
LASW10
This message was edited by lasw10 on 2002-11-07 10:41

 

[kskinne]

if cell A1 contains your value 1021107, this would also work:

=DATE("20"&MID(A1,2,2),MID(A1,6,2),MID(A1,4,2))

hth
kevin

 

[Juan Pablo González]

Use Text To Columns, using "Delimited", and in step 3, change the column type to "Date" using YMD or YDM, because I don't know which one are you using in there !

 

[neilb]

All

Many thanks for all your quick responses. It now works a treat.

Neil