Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Christina Agyeman
Starting Member
15 Posts |
 Posted - 2002-07-10 : 07:09:56
|
| I have the following expression that evaluate whether Thedate property on the time member is greater than today date.IIF(Ancestor(Time.currentmember,Time.month).FIRSTCHILD.Properties("Thedate") > DATE(),"YES","NO")The problem is that everything evaluate to NO. Could you tell me what I am doing wrong. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-07-10 : 07:49:56
|
| may I suggest that you print both values before the IFF statement....you might be surprised as to the contents (or more probably the format) of the relevent data itemseither your data is truly old...and thus satisfies the condition...or the logical condition ">" should be reversed?or the format of the data on one or other side of the equation is such that the condition is evaluating to an answer of "NO".... |
 |
|
|
|
|
|
Date comparison