Prev: Pharm and Oracle Clinical
Next: Convert Character into numeric
From: chittiprolu pradeep on 18 Feb 2010 10:20
Hi All,

I have a dataset containing Start_Date and End_Date variables which are in
datetime format (i.e., 10Jan2010:00:00:00) and this dataset contains one
year data.

Now I pulled this dateset in to DI studio and created target dataset. Here I
am in need to create a variable called 'period' and based on this period
variable I need to filter the data
(i.e., If i want to pull the data of last year only dec month then I should
be able to pull the dec month data by period and I need to get the data
starting from Dec 1st to Dec 31st only.)

Could any please help in this how can I achieve this in DI studio or in
which transformation it is possible or any etc etc etc....

Thanking you all very much for support.

Thanks
P
 | 
Pages: 1
Prev: Pharm and Oracle Clinical
Next: Convert Character into numeric