해결됨

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?

이 주제는 답변이 닫혔습니다.

최고의 답변: 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#

답변

Adobe Champion, Community Advisor, UG Leader

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

가입하기