Articles in this section

See more

What MQL query can be used to show all stories entered in last 30 days?

Avatar
Bryan Pearson
Updated
Follow 

A customer of mine wants to see all stories entered in last 30 days.  I already show all stories entered 'today':   table query: SELECT Number, 'Product Name', name WHERE 'Date Created' IS TODAY 

But I how do I adjust to show the last 30 days worth?

Thanks!

Bryan

Related articles

Comments

1 comment

Sort by Date Votes
  • Avatar
    Jay Mitchell

    Hi Bryan,


    It looks like you've set up a "Date created" property to capture when the card is created. You can use this property in a formula property. If you create a formula property named, "Date Created plus 30" with a formula of:


    "Date Created" + 30

    then you could compare that to TODAY in MQL.


     {{ table query: SELECT Number, 'Product Name', name WHERE 'Date Created plus 30' >= TODAY }}

    Hope that helps,


    Jay

    0
    Permalink

Please sign in to leave a comment.