Post reply

Dynamic date filters

  • December 6, 2007 at 6:47 am

    #62320

    Hey,

    Is it possible to create a sql clause with dynamic date filters?

    Like a datefilter containing (lastyear to date) or (this year to date)?

    //MG

  • December 6, 2007 at 6:51 am

    #757633

    Do you have an example?

  • December 6, 2007 at 11:03 am

    #757778

    Yes sure.

    I have a table with orders, in that table i have a field called amount.

    I would to show a summerized amount for this year to today (01/01/07 - 12/06/07) and last year until today (01/01/06 - 12/06/06) - and again tomorow (01/01/07 - 12/07/07) and (01/01/06 - 12/07/06).

    //MG

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply