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



1 comment

  • 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,


    Comment actions Permalink

Please sign in to leave a comment.