HELP!!! Passing a Date from a HTML Text field into WF

[MJPPaba]

I have a HTML Page with a Text field containing a date e.g.
30/05/2003.

This date field is to be used as a &DATEFROM variable. My problem is when it gets passed into Webfocus and is compared to the field of dates, the &DATEFROM field is recognised in A10 format or similar, however the date field is in the format HMDYY format.

Here is the code that I am using currenlty...

PRINT
ALLDATES
WHERE ( ALLDATES GE '&DATEFROM');

Cheers

Matthew Paba

 

[kaeserea]

Hi Matthew,

HTML field values are always passed on to webfocus as a string. So you'll have to convert the string format to Date format.

Regards
Eva

 

[MJPPaba]

Hi Eva,

I had pretty much given up hope of passing through a date value. Thanks for your kind reply, you're a star.

Cheers

Matthew

 

[focwizard]

Matthew,

Actually, you have TWO problems. The first is, you've specified your field's date format as MDYY, but the value you pass in is DMYY. So, the order of the components is different.

Second, when testing on a literal for a 'H' format field, you must use the DT function, to indicate that the value is a date-time constant. Thus, the test should look like this:

WHERE (ALLDATES GE DT(&DATEFROM))

This assumes that &DATEFROM is in a MDYY format, matching the format of ALLDATES.