Converting Date Format

[selzlerb]

Hello Team,

I'm looking for a good way to change date formats from;

20060922

to

09/22/2006

I've been playing around with the text and date functions within a calculation field but I'm getting nowhere pretty fast.

Any help here would be greatly appreciated.

Thanks.

- Sez

[John Mark Osborne]

Show all the records and then select the MYTABLE::date field so the cursor is blinking in it. Use the formula below in a Replace Field Contents calculation after you have made a backup.

Date(Middle(MYTABLE::date; 5; 2); Right(MYTABLE::date; 2); Left(MYTABLE::date; 4))

[ThatOneGuy]

Nice and succinct, Mr. Osborne! And will it work without any delimiters, like a slash (/) or a dash (-) ?

Just curious...

[comment]

No delimiters are required when the length is fixed - i.e. days and months <10 are padded with a leading zero.

[ThatOneGuy]

Thank you both!

[selzlerb]

John,

Thanks! That works great! I appreciate the help.

- Sez

Edited October 22, 2006 by Guest