help with >= <= variables in a trigger

hopkinsc — Thu, 26 Feb 2015 17:01:39 GMT

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?

Re: help with >= <= variables in a trigger

jpenuliar — Thu, 26 Feb 2015 17:28:14 GMT

Hi Hopkinsc,

have a look at attached file courtesy of Colin Albert

Fri, 27 Feb 2015 06:55:28 GMT

I use (admittedly in a load script)

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