Skip to Content
0
Former Member
Dec 13, 2010 at 07:36 AM

How to get minimum date in Universe

27 Views

Dear All,

I have two date in my Universe which is based on MS SQL 2005.

I want to store minimum date in 3rd field.

I have created 3rd field in universe and I have tried with below case statement:

Case Date1>Date2

Then Date2

Else Date1

End

But during parsing, I am getting the "statement could not be prepared" error.

Am I missing something ?

I really appreciate your input on this.

Regards,

Rishit Kamdar