Reoprt builder 2.0 expression help
Can anybody tell me where I'm going wrong with this? =IIf(FormatDateTime(Fields!Date_Registered.Value, DateFormat.ShortDate) >= "01/04/2009" AND (FormatDateTime(Fields!Date_Registered.Value, DateFormat.ShortDate) >= Today(), "T","F") Many thanks in advance
January 28th, 2011 9:02am

Hi PROLBB, From your expression, I notice that there is unnecessary "(", so please modify it to below and have a try: =IIf(FormatDateTime(Fields!Date_Registered.Value, DateFormat.ShortDate) >= "01/04/2009" AND FormatDateTime(Fields!Date_Registered.Value, DateFormat.ShortDate) >= Today(), "T","F") If you have any question, please feel free to ask. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 10:04pm

Hi, Please use the following expression =IIf(FormatDateTime(Fields!Date_Registered.Value, DateFormat.ShortDate) >= "01/04/2009" AND FormatDateTime(Fields!Date_Registered.Value, DateFormat.ShortDate) >= Today(), "T","F") Let me know if any queries.Thanks, Pranil Yambal | Pranil.Yambal@hotmail.com
February 2nd, 2011 12:08am

Many thanks Challen. I'll try it out and get back to you.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 8:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics