Date

[ParthKoul1]

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 ?