How to remove single date from a date column ?

[Sai_Mohan]

Hi All,

I have a date column where i need to remove two dates from the column. I need only the morning(am) Dates in this field. so i wanted to remove 17 Jan11 evening dates .

For Example:

Assume , My Field_name is Datefield. it contains some values like

19/01/2011 8.23am

18/01/2011 7:34am

17/01/2011 8:45am

17/01/2011 12:15pm

17/01/2011 3:15pm

20/01/2011 8:45am

 In the above values, I need to remove two dates which is highlighted. What will be the solution to do that?

Thanks 

Sai

[sunny_talwar]

Remove this in the script? You can use Where clause

Where Frac(Datefield) < MakeTime(12);

[Sai_Mohan]

Thanks for the reply!!

Can you please help me with the expression which i can use that in the way of set analysis expression(Measure) ?

Thanks in advance.

[Sai_Mohan]

Thank you Sunny!

I got the solution from your previous post

View Solution