help with >= <= variables in a trigger

[hopkinsc]

Hi all,

I am looking for some help with a trigger to put a variable value against a date field.

I have a calendar which writes the selected date to a variable (vFromDate) and another calendar that writes the end date (vToDate).

These values appear in the variable as numbers, i.e. (41661) which is 22-Jan-14.

i want to assign the values of these variables against a date field (UsageDate) which is in the format DD-MMM-YY.

I have created a button and i need to set an action against it for 'Select in Field' but unsure on the syntax to get this to work.

Can anyone help please?

[jpenuliar · Accepted solution]

Hi Hopkinsc,

have a look at attached file courtesy of Colin Albert

[#3]

I use (admittedly in a load script)

Date(purgechar(datefield,'[]'), 'DD-MMM-YY')