Hello
I need to filter people from my targeting with date of birth is between for example Aug 21 and Dec 23.
I tried a query like:
day of date of birth of targeting dimension greater than or equal to 23 and month of date of birth of targeting dimension greater than or equal to 8
But seems not what I want, I need to send a communication for the people when date of birth is between this two dates above. Any ideas?
Thank you
Solved! Go to Solution.
Perhaps something like the following?
0|Month(@birthDate)|12|=|||||0|/|0 0||||AND||||1|/|0 0|Day(@birthDate)|21|>=|||||0|/|1 0|Day(@birthDate)|23|<=|AND||||0|/|1
<ctx helpCond="Query: month of date of birth equal to 12 and (day of date of birth greater than or equal to 21 and day of date of birth less than or equal to 23)"> <queryDef hideOrderby="true" hideSelect="true" label="Recipients" namespace="nms" operation="select" schema="nms:recipient" startPath="/" xtkschema="xtk:queryDef"> <where displayFilter="month of date of birth equal to 12 and (day of date of birth greater than or equal to 21 and day of date of birth less than or equal to 23)"> <condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="Month(@birthDate) = 12" internalId="0"/> <condition boolOperator="AND" internalId="1"> <condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="Day(@birthDate) >= 21" internalId="2772501133"/> <condition compositeKey="" dependkey="" enabledIf="" expr="Day(@birthDate) <= 23" internalId="2774336146"/> </condition> </where> </queryDef> <ignored _isNewEntity="false"/> </ctx>
Perhaps something like the following?
0|Month(@birthDate)|12|=|||||0|/|0 0||||AND||||1|/|0 0|Day(@birthDate)|21|>=|||||0|/|1 0|Day(@birthDate)|23|<=|AND||||0|/|1
<ctx helpCond="Query: month of date of birth equal to 12 and (day of date of birth greater than or equal to 21 and day of date of birth less than or equal to 23)"> <queryDef hideOrderby="true" hideSelect="true" label="Recipients" namespace="nms" operation="select" schema="nms:recipient" startPath="/" xtkschema="xtk:queryDef"> <where displayFilter="month of date of birth equal to 12 and (day of date of birth greater than or equal to 21 and day of date of birth less than or equal to 23)"> <condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="Month(@birthDate) = 12" internalId="0"/> <condition boolOperator="AND" internalId="1"> <condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="Day(@birthDate) >= 21" internalId="2772501133"/> <condition compositeKey="" dependkey="" enabledIf="" expr="Day(@birthDate) <= 23" internalId="2774336146"/> </condition> </where> </queryDef> <ignored _isNewEntity="false"/> </ctx>
Hi @rbiri
You can also try creating the below query
which will give the result as
filtered to
If you want all the records regardless of the year then you can choose the query below
Regards
Hi @rbiri,
Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies