Multiple Date Filters

srinictsrinict Member Posts: 58
Dear Friends,

I have one requirement like, My form should display Purchase qty for day, Purchase Qty For Month and Purchase Qty For Year. Like this i need some more things for the same month and year. For this one i created one new table and there i am putting all the fileds as flow fields. For Day we can get by setting Table Filter as "Posting Date" = "Date Filter". But I am unable to get the values for Month and Year. If any one of you have the solution, i am really thankfull to them. Can any one please let me how to use date filter like

"Posting date" >= Months StartDate "and Posting Date" <= MonthEndDate.

Thanks in Advance.

Regards,
Srinivas ](*,)

Comments

  • BeliasBelias Member Posts: 2,998
    setrange("posting date","startdate month","enddate month");
    
    If the feature fits your project, you can reuse the buttons to change the filter from day to week, month, quarter,year...i don't remember the worldwide form...i have these buttons in an italian localized form :-k

    EDIT: found it! number 154
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • srinictsrinict Member Posts: 58
    Thanks for your reply, but i did not get any form like that.

    Regards,
    Srinivas
Sign In or Register to comment.