date conversion

[rajmns]

I have a date column in numeric format. Oct 2007 for eg., is stored as 2007-10. A prompt is based on the column. The value selected in the prompt selected should be displayed on report list header as October 31 2007. Any inputs as to how to do that?

Thanks in advance.

 

[blom0344]

CASE 
WHEN 
substring(field,6,2) = '10'
THEN 
'October 31'||' '||substring(field,1,4)
WHEN 
substring(field,6,2) = '11'
THEN 
'November 30'||' '||substring(field,1,4)
.....
.....
.....
ELSE NULL END

Ties Blom

 

[rajmns]

works great!!! thanks so much.