This discussion is archived
3 Replies Latest reply: Feb 26, 2013 10:30 AM by AlexAnd RSS

Character and date values in a char column

bip_monkey Newbie
Currently Being Moderated
Hello,

I have a temp table in which one of the columns has to be defined as a char. The purpose of this column is to contain all the begin dates of a rent term. However, the users want to display 'Commencement' for the first rent term, for the rest the dates formatted as 'MM/DD/YYYY'. When the data gets into the table it is going in as '01-FEB-08' for the all the terms other than the first term...hence that is how it comes out in the xml structure.

In my template i have the following code for the field:

<?xdofx: if REFFDATE ='Commencement' then 'Commencement' else to_date(REFFDATE,'M/d/yyyy') end if?>

It is not working....I still see the dates in the 'DD-MON-YY' format. Is there a way to accomplish this? If yes, pls. help.

Thanks,

Monkey

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points