Data range with >= not wokring in segmentation

[VarnikaJa1]

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?

[SatheeskannaK · Accepted solution]

@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#

[VarnikaJa1]

Hi @SatheeskannaK 

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.