Date format in form report with derived field

[christimess]

Hi, I hope you had a great weekend!

I am creating letters using forms. I'm creating the body of the letter in a derived field as I am using text and fields from other tables.
So for example the body derived field may state:

'Based on your rehire date of ' || "PS_EMPLOYMENT"."REHIRE_DT" || ' we would...

Well when the report runs the results appear as:

Based on your rehire date of 11-JUL-2007 we would...

How do I get it to change the format of the date?

I don't understand why it's doing this as when you run a columnar report the date appears of 7/11/07.

Thanks for your assistance!

 

[ArtieArt]

Question.
Are you an oracle or sql_server database client? I would format the date field within the derived field, either using the TO_CHAR or the compatible sql_server function under the Date selection. Copy you derived field and place it in the reply. I will forward the formula......

Artie Dunnings
ADTECH Consulting Inc
HRIS Functional & Technical Trainer
Alpharetta, GA

 

[christimess]

Thank you, Thank you, Thank you Artie. I was trying TO_DATE and it worked with TO_CHAR.