How can i convert the variable "Filter" from text

gulamdastagir

Hi

Filter: variable(text)

OnPreReport() Trigger :

Filter :=Item.GETFILTER("Date Filter");

How can i convert the variable "Filter" from text to "date"?

ara3n

a datefilter can be range so you can't just
evaluate(mydate,datefilter); will only work if they specify one date.

DigiTecKid

gulamdastagir wrote:

Hi

Filter: variable(text)

OnPreReport() Trigger :

Filter :=Item.GETFILTER("Date Filter");

How can i convert the variable "Filter" from text to "date"?

Hey Gulamdastagir,

You can use the GETRANGEMAX and GETRANGEMIN functions.

EXAMPLE...

BeginDate: variable(date)
EndDate: variable(date)

BeginDate := Item.GETRANGEMIN("Date Filter"):
EndDate := Item.GETRANGEMAX("Date Filter"):