Hi Everyone,
I need some help in getting records for only past 18 months from today's date.
Load
if(len(PORCMD) = 4, mid(PORCMD,1,2) & '/' & mid(PORCMD,3,2) & '/' & ((((PORCCC + 19 ) * 100 ) + PORCYR )),
if(len(PORCMD) = 3, mid(PORCMD,1,1) & '/' & mid(PORCMD,2,2) & '/' & ((((PORCCC + 19 ) * 100 ) + PORCYR )),'')) AS [Date Required]
is my Date column.
Also kindly mention while putting in the where clause should it be pre loaded ?