Hidden expression with dates?

Hot Topic

Problem passing columns as parameter!
Rowversion as a history mechanism
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18., ;
Initialization problem
ASP Update Method not working after a MSDE to MSSQL 2005 Expess Update
SSRS 2000 SP2 cannot export to Excel due to a large field
SQL & Passwords
Does it exist a boolean data type in SQL SERVER ?
Question about by Import oracle data and field is null
Any Distributed Data failure

SQL Server

SSIS package very slow in design
Use measures from 2 cubes merged in a virtual cube
Trouble with DataSource and Sharepoint Integration
Basic Full Text search question
Direct vs. Indirect Package Configurations
Help with SQL
Data driven subscription
How do you backup a database using sql server 2005 express???
sp_executesql and speed
"No description found" when saving a package

Hidden expression with dates?

Hi! How to write the syntax when you try to compare the dates. In this case I try to check if the date is empty(then it's 1/1/1900) then the field should be hidden. This is what I tried but didn't succeed:

=iif(Fields!ModifiedDate.Value="1/1/1900",true,false)

Answer this question

Hidden expression with dates?

  • Alba

    You can convert your string value ('1/1/1900') to a date with the CDate() function. With this you can compare the to value's with each other.

  • parlance

    It just the otherway round: =iif(Fields!modifiedDate.Value=CDate("1/1/1900"), false, true)



  • Warren13

    Jan Pieter Posthuma wrote:
    You can convert your string value ('1/1/1900') to a date with the CDate() function. With this you can compare the to value's with each other.

    Thanks for the post but unfortunately I didn't get it. The main problem is syntax - I don't know where to use Cdate() -function. I tried this:

    =iif(Cdate(Fields!modifiedDate).Value) > "1/1/1900",false,true)

    the compiler didn't like it :)

    Can you give me an example


  • Hidden expression with dates?
Answer this question