Simple VBA Code Question

Question

Hi,

I am trying to bring back records from a table called CTN_LIST where the created date is no older than 90 days. The code is below (created_dt<=-90)

Set PlatinumList = db.OpenRecordset("SELECT FORMATTED_CTN FROM CTN_LIST 
WHERE ((Status='Available') AND (Category='Platinum')) AND (In_Offer_List = True) 
AND (Created_DT<=-90);", dbOpenSnapshot, dbReadOnly)

Can someone please tell me the correct date format to ensure that I only bring back records that are less than 90 days old?

Thanks

Answer 1

Try using Created_DT <= DATEADD(d, -90, Created_DT) in your query.