Expand my Community achievements bar.

SOLVED

Data range with >= not wokring in segmentation

Avatar

Level 1

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
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.

SatheeskannaK_0-1708990547431.png

SatheeskannaK_1-1708990582717.png

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

Thanks, Sathees

View solution in original post

2 Replies

Avatar

Correct answer by
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.

SatheeskannaK_0-1708990547431.png

SatheeskannaK_1-1708990582717.png

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

Thanks, Sathees

Avatar

Level 1

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.