VBScript Needed Plz : I have the below SQL query that return dates, I need to evaluate the dates and result only dates older than today by one day only. Appreciate your Help


SELECT Address,max(Date+ ' ' + time)as last_Trans_time FROM AxA_Transactions where address is not null GROUP BY Address

Thanks in Advance