Convert String to Date

[rutgers]

Hi there,

I hope someone can help me...

I'd receive records for dates that are in string format DD-MMM-YY (e.g. 01-DEC-08). I would like to convert this field into a date format so that I will eventually be able to write a formula to subtract this date from another.

Is this possible to do? If so, how?

Thanks in advance for your help!

 

[lbass]

You should be able to create either a formula or a SQL expression like this:

cdate({table.stringdate})

-LB

 

[rutgers]

Thank you!! You are a star!