Caption of the field in the form

njaiku

Hi,

I have a form with two date variables as starting Date and Ending Date.If the user enters the starting date and ending date (ex starting date = 18/10/2008 ; ending date = 02/02/2009).

I have to display the column as Oct2008|Nov2008|Dec2008|Jan2009|feb2009 in the form itself.

Is it possible to change the caption of the field in the form according to the starting and ending date .

Suppose if my starting date = 01/12/2008 and ending date 22/01/2009, then the column should be display as Dec2008|Jan2009.

So the caption of the field must be change dynamically. Is it possible???

Albertvh

Hi,
You could try and use the FORMAT statement to do this. I'm assuming this is a matrix form.

FORMAT(Date,0,'<Month Text,3><Year4)

Hope this helps

Albert