Hi,

I am trying to do something rather simple and
am having problems with it.

I want to reformat a character date value from a YYYYMMDD format to another character type date value that is in a MM/DD/YYYY format.

Thank you in advance.

Tom

With assistance from a co-worker, I have my answer. Hopefully the below will help someone having a
similar challenge.

-> to convert the alpha date from YYYYMMDD to MMDDYYYY... targetDateField/A8=CHGDAT('YYMD', 'MDYY', sourceDateField, 'A8');

-> to introduce the date separators... formattedDate/A10=EDIT(targetDateField, '99/99/9999');

Being an alpha field you could have also use EDIT.

targetDateField/A8=EDIT(sourcedateField,'99/99/') | EDIT(sourcedateField,'$$$$9999'); 

Ooops got the format wrong.

As per Madhumitha's post

This message has been edited. Last edited by: Waz,

hi,
you want to convert a character date value from yyyymmdd to chatacter date value of mm/dd/yyyy right, then the following code will help you.

targetfield/A10=EDIT(inputfield, '$$$$99/99/')|EDIT(inputfield, '9999')

it will convert yyyymmdd format to character date of mm/dd/yyyy correctly

Eg: inputfield =20080301
then outputfield=03/01/2008

Regards,
Madhu

This message has been edited. Last edited by: Madhumitha,

TomG,
If you are going to be dealing with dates often I would recommend that you get use to working with the DATECVT(DATE-FIELD,'IN-FORMAT','OUT-FORMAT') function.

Anytime I'm dealing with dates I seem to require moving to and from smartdates or expressing my date in a format other than what has supplied from my data.

Waz,
What wrong format you got according to my post???

Just saying that my original post had the format of the date wrong, where yours was right

AAARGH. I've tried everything I can think of. Nothing works.

I have a field in the database defined as A10. The actual data in the field is 9/30/2011
I want to convert this to 2011-09-30.
How can I do this?

Never mind. I don't need this afterall.