I see. I didn’t know if SQL could select all the records and order (sort) by a field, whether null or not, and then sort by post date. I was also curious if an OR would work using promotion date/post date – but I’m not very familiar with SQL.
To solve my issue, I just placed start (post) date in the promotion field for all records. There’s a limited number of records (posts) so it wasn’t difficult to do, I just would rather have done it logically.
Thank you.
-
This reply was modified 5 months, 2 weeks ago by cwcrogan.