elliot315
Mr. Question
- Local time
- Today, 04:44
- Joined
- Jun 3, 2007
- Messages
- 98
I have a field which holds a date(FieldDate)
and I have another field that calculates a field depending that date
I am using an IIF statement that go like this
IIF(FieldDate<= 08/20/07,1.5,1)
how do I write that field value (date) so the iif works, I guess thats the error that i can not use the date in that format... which format do I have to use?
and I have another field that calculates a field depending that date
I am using an IIF statement that go like this
IIF(FieldDate<= 08/20/07,1.5,1)
how do I write that field value (date) so the iif works, I guess thats the error that i can not use the date in that format... which format do I have to use?
