Hi Mirzay,
Try this instead:
{
"or": [
{
"last": {
"count": 180,
"offset": 0
},
"custom": true
},
{
"include": {
"members": [
null
]
}
}
]
}
Thank you for the response Priyanka. I am not getting the expected result.
(Converted to Months instead of days but tried both ways)
I am expecting the range to be last 6 months to end of next month. What I get are these dates.
You can use this script to get the range to be last 6 months to the end of next month:
{
"or": [
{
"last": {
"count": 6,
"offset": 0
}
},
{
"next": {
"count": 1,
"offset": 1
}
}
]
}
I am using your filter formula to filter for a date that is Null or the date occurred in the last year. The result is picking up all years and also the null value. How can I restrict to filter to last year and null values?
{
"or": [
{
"last": {
"count": 1,
"offset": 1
},
"custom": true
},
{
"include": {
"members": [
null
]
}
}
]
}
