Query.createCondition that only includes transactions whose createddate is less than or equal to 231 days ago

AI generated answer (using internal Slack threads):

To create a condition that only includes transactions whose createddate is less than or equal to 231 days ago, you can use the

query.Operator.ON_OR_BEFORE

operator with a

Date

instance that represents the date 231 days ago. Here is an example:

javascript
var date231DaysAgo = new Date();
date231DaysAgo.setDate(date231DaysAgo.getDate() - 231);

var myQueryConditionCreatedDate = myQuery.createCondition({
    fieldId: 'createddate',
    operator: query.Operator.ON_OR_BEFORE,
    values: [date231DaysAgo]
});

In this code,

date231DaysAgo

is a

Date

instance that represents the date 231 days ago from the current date. The

createCondition

method is used to create a condition that matches transactions whose

createddate

is on or before

date231DaysAgo

. Please note that this code assumes that

myQuery

is a

query

instance. You would typically create such an instance using

query.create

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******