How can i write a condition for like isdate(Fields!DueDate.value)
I tried isdate but i am getting an error message. what is the equivalent for isdate in sql server reporting services formula fields or calculated fields expression.
Thank you very much for the information.
*********************************************
=IIF(isdate(Fields!DueDate.Value), ................
********************************************
Reddy,
Try
=IIf(IsDate(Fields!DueDate.value),"True","false")
This should work for you.
Ham
|||Sorry should have read it all.
=IIf(Fields!DueDate.value is nothing,"False",IsDate(Fields!DueDate.value),"True","false"))
Ham
|||
There was a program error, I left out the next IIF statement
IIf(Fields!DueDate.value is nothing,"False",IIf(IsDate(Fields!DueDate.value),"True","false"))
No comments:
Post a Comment