Confirm SQL Code for List Manager

You could also use existing list criteria to achieve, for example:

Hi Thomas,

Thanks for your inputs. How would you do, if you are interested to know how many "First Time" buyers whose accounts were created within last 30 days from today? 

Are those criteria staying the same? 

Please advise.

Best,

Tom Nguyen 

Hi Thomas,

Thanks for your inputs. How would you do, if you are interested to know how many "First Time" buyers whose accounts were created within last 30 days from today? 

Are those criteria staying the same? 

Please advise.

Best,

Tom Nguyen 

With date criteria you can use the 'relative' function which you can specify number of days or number of months before or after the run date (date the list is generated). As it's relative it will be 30 days ago from when you run the list. It should achieve the same as your SQL query and if you add those list criteria and then click show query it will show you the SQL code behind the list criteria you input.

There's some more info on the help system https://www.tessituranetwork.com/Help_System/Content/Criteria%20Sets/Date%20Value%20Considerations.htm

Here's an example and options with relative dates