Hi all,
I'm trying to create a list, in list manager, that will pull birthdates based on the month someone was born, and not the year or day.
I was wondering if there was a way to put a wildcard below on the year and day, so it just pulls everyone for instance born in November.
Any help will be greatly appreciated.
Many thanks
Lee
SELECT DISTINCT a.customer_noFROM V_CUSTOMER_WITH_PRIMARY_GROUP AS a WITH (NOLOCK)WHERE a.inactive = 1 AND EXISTS (SELECT * FROM TX_CUST_KEYWORD WITH (NOLOCK) WHERE TX_CUST_KEYWORD.customer_no IN (SELECT customer_no FROM V_CUSTOMER_WITH_PRIMARY_GROUP WHERE customer_no = a.customer_no) AND CONVERT (DATETIME, TX_CUST_KEYWORD.key_value) = '2023/11/01' AND TX_CUST_KEYWORD.keyword_no = 1)
Lee, I have a super-simple list criteria set up for each month and the wildcard looks like this...
Thank you Sue, that's great and really helpful.
Sue Llende said:have a super-simple list criteria set up for each month and the wildcard looks like this
Neat code, which might even work for bad, old, converted birthdate data (like some of ours), which aren't strictly in SQL datetime format.