11-11-2014 11:31 AM
Hey all, I'm finding myself hitting a brick wall here and I'm sure it's silly.
create table recentapplication as
select * from fulltable where
.entered_date > intnx ( "month" , today() , -1 ) ;
It's returning all entries.
If I change it to entered_date > today() - 30 that works though I'm looking to do it from the beginning of previous month whenever I run it.
I'm sure this is just a stupid thing on my part but I'm slowly losing my sanity. Any help would be greatly appreciated.
11-11-2014 11:43 AM
That's odd, the following program works fine for me. note there is a typo in your code - dot before the entered_date. Are you also sure the entered_date is a date variable? Perhaps post test data where this fails?
create table RECENTAPPLICATION as
where ENTERED_DATE > intnx("month",today(),-1);