select records where the date (in date time format) is less than today

[tparvaiz]

Hi,

I have a field (table_date) that's in date time format: (sample: 08MAY2017:08:00:00.000) and I want to select records where the date is less than today()

here is what I have so far but it's not working

proc sql;
create table temp_del1
as
select * from temp_weekly_data
where
datepart(table_date) < datepart(today());
run;

please advise

[art297 · Accepted solution]

Remove the datepart function from the today() function. i.e.,

datepart(table_date) < today();

Also, end your proc sql call with a quit; rather than a run; statement

Art, CEO, AnalystFinder.com

[tparvaiz]

thanks for your assistance