Re: Selecting dates in a period. Was RE: new joinee

  • Follow


My problem is i created a variable called 'Period' by the logic
"MDY(month(today()),1,year(today()))-1" which will return the value as
FEB2010. And now the i need to pull the data based on this period variable
(FEB2010) from the 5 years of data. Here this data contains 5 years of data
and I only need Feb2010 data only.

And here i have two variabels Start_date and Class_Date and I wrote like
this

Month(period) between month(datepart(start_date)) and
month(datepart(end_date)) but some how its not working fine... is dre any
other way to get the data please....
0
Reply sasbond1981 (5) 3/9/2010 3:06:05 PM


0 Replies
185 Views

(page loaded in 0.029 seconds)

Similiar Articles:













7/25/2012 11:43:44 PM


Reply: