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

Follow

Comments

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,


    Jay

Please sign in to leave a comment.