How can i convert the variable "Filter" from text

gulamdastagir
gulamdastagir Member Posts: 411
edited 2006-10-17 in NAV/Navision Classic Client
Hi

Filter: variable(text)

OnPreReport() Trigger :

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

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

GD

Comments

  • ara3n
    ara3n Member Posts: 9,258
    a datefilter can be range so you can't just
    evaluate(mydate,datefilter); will only work if they specify one date.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DigiTecKid
    DigiTecKid Member Posts: 46
    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"):

Categories