date function question in AJO advanced expression editor

[chrisyan]

Hi There,

which date function below can help me use 

#{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date}  -7 days < now() that's the query I am looking for but idk which date function is feasible:

[vraghav · Accepted solution]

@chrisyan you can use this formula inNextDays, assuming #{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date} is of type datetime otherwise wrap it under toDateTime() function as I've done below.

inAudience("Your audience name") and 
inNextDays(toDateTime(#{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date}), 7)

[chrisyan]

Thank you.

can you help compose an expression to compare with now() current date and I wanted to calculate a clear date value by tsExpect_date field ex: format '2025-03-08T00:00:00.000Z' that's added +7days that will be used in the Advance query Editor within journey conditional activity to check every profile if their touchpoint date is on or before today's date.