Solved

Data range with >= not wokring in segmentation

Hello All,

I am querying customers who purchased within a specific date range.

E.g., purchaseDate>=06/05/2023 and purchaseDate<=06/15/2023.

The output does not contain customers purchased on the dates mentioned i.e. 5th and 15th June; but only from 6th to 14th.

Does >= condition does not work in ACS segmentation?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by SatheeskannaK

@varnikaja1 It should work. Take a look at this example where I have 4 events between 10/17/2023 to 10/25/2023.

This how it will look in the advanced mode: @eventDate >= #2023-10-17T05:00:00Z# AND @eventDate < #2023-10-26T05:00:00Z#

Accepted solution

Community Advisor

@varnikaja1 It should work. Take a look at this example where I have 4 events between 10/17/2023 to 10/25/2023.

This how it will look in the advanced mode: @eventDate >= #2023-10-17T05:00:00Z# AND @eventDate < #2023-10-26T05:00:00Z#

Thanks, Sathees

Thank you for your response. Our query was generating different dates in advance mode because of difference in timestamp.

System timestamp was different compared to transaction schema date. So we were not getting desired results.

Sign up