Date

[korata]

I have a field name called letting in my oracle 9i data base.I would like to convert the value of this field to Month/Date/Year and eliminate the last to digit.I am using CR 8.5
E.G 04082701 I would like this field to appear like this 08/27/04 in my CR report .
thank you

 

[Turkbear]

Hi,
Is it a Date type field in the data base?
What is the 01 ?

You can format dates with the CR totext function - see the help file for format options.

 

[korata]

It is a string field in the database and i do not claim to understand well what 01 is but i am very certain that the six digits " 040827" are refering to the year, month and date.
thank you

 

[bdreed35]

You can try this:

cdate(mid({table.letting},3,2) & "/" & mid({table.letting},5,2) & "/" & left({table.letting},2))

~Brian

 

[korata]

Thank you for the help.It worked fine for me.