Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date comparison syntax 1

Status
Not open for further replies.
mjd3000

mjd3000

Programmer
Apr 11, 2009
136
GB
I am trying to change the backcolor of a cell on the condition that the value in a date field is less than Now. Does anybody know what I am doing wrong?

=IIF(Fields!End_Date < Now, "DarkRed", "White")
 
Sort by date Sort by votes
Are they in the same format? You may want to use DateValue() on teh End_Date. Are you getting an error or is it just not working for you?

--------------------------
Web/.net Programmer & DBA
Central PA
 
Upvote 0 Downvote
Code: 
=IIF(Fields!End_Datep[b][COLOR=#ff0000].Value[/color][/b] < Now, "DarkRed", "White")
 
Upvote 0 Downvote
Oops. I figured it out. Add ".Value." Try:

Code: 
=IIF(Fields!End_Date.Value < Now, "DarkRed", "White")

--------------------------
Web/.net Programmer & DBA
Central PA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
SQL syntax problem
Replies
5
Views
719
MarkSweetland
MarkSweetland
newbieSSRS
  • Locked
  • Question
SSRS - DAte fileld filter and collapsing
Replies
0
Views
191
newbieSSRS
newbieSSRS
feltonam
  • Locked
  • Question
How to select Patients with &gt;5 Appts and get the very 1st Appt date in same Script
Replies
1
Views
218
johnherman
johnherman
dgillz
  • Locked
  • Question
Date Range Parameter not available?
Replies
2
Views
224
dgillz
dgillz
xarzu
  • Locked
  • Question
with what I hope to be a parameter for a date/time variable. The business requirement is that I pa
Replies
1
Views
198
xarzu
xarzu

Part and Inventory Search

Sponsor

Back
Top