Re: Forms 5.0.6 - date formats

Hi,

use an additional Display Item for the Date field. Create a when-validate-item Trigger for the Display-Item where you call the function

function string_to_date(source in varchar2,

  		      formats in varchar2 default 'DD-MON-YYYY',
                  separator in varchar2 default ',') return date IS ...

This function comes with the d2kconv.pll.

Parameter source is your Display-Item,
formats is list of formatmask which where allowed for the input, separator is character that separates the formatmask in the parameter above.

e.g.

date := string_to_date ( dsp_item, 'DD-MON-YYYY,DD.MM.YY,DDMMYY', ',' );

But test it, i think there some bugs in this function.

Kay Received on Wed Feb 10 1999 - 08:32:20 CET