Months Calculations
Posted: Fri Aug 24, 2007 12:10 am
I want to get the rows having date created greater than 1st day of (todays date - 6 months ) as below
Todays Date - 24-Aug-2007
Then i want the rows from [1st day of (24-aug-2007 - 6 months = 24-feb-2007)] i.e 01-feb-2007
I have some manipualtions ans look-ups so i cannot implement this logic in database through query. I want this to be done in Constraints of transformer.
Thanks in Advance
Todays Date - 24-Aug-2007
Then i want the rows from [1st day of (24-aug-2007 - 6 months = 24-feb-2007)] i.e 01-feb-2007
I have some manipualtions ans look-ups so i cannot implement this logic in database through query. I want this to be done in Constraints of transformer.
Thanks in Advance