Skip to Content
0
Former Member
May 08, 2008 at 05:26 PM

Covert string field to date and pass date range values

33 Views

Post Author: punty

CA Forum: General

Hi All,

One of the column which is of varchar datatype stores date information in string format like JAN-00, AUG-06, DEC-06, JUN-07, AUG-07. My requirement is to convert this into date format and use it in selection formulas. I want to pass date range values against this column.

Any help on this is highly appreciated.

Thanks in advance.