help with expression

W

Wildman

=IIf(Date()<#7/29/2005#,IIf([JUL05TOTDOLLARSASS]=0,Format(0,"Percent"),Format([JUL05DOMDOLLARSASS]/[JUL05TOTDOLLARSASS],"Percent")),"")

This expression does not seem to recognize the pc's current date and always
produces the false portion of this expression ,"") even when it should be
true.

How should this be written to correct the problem.

Help?
 
D

Douglas J Steele

Um, today's date is September 7th. You're comparing against July 29th. It
should return false...
 
Top