Timestamp fields and queries

If the contact source of a program is a query that uses a timestamp field, the program does not pull in contacts because a query is not able to calculate the timestamp field correctly.

Although a classic query can calculate correctly, classic queries cannot be associated to a program as the contact source.

Instead of using a program for your automation solution, evaluate your automation needs, and see if an hourly recurring automated message group could work for you, because you can associate a classic query to an automated message group.