HI, I’m still new and self taught to Notes design and this is the first post for me, so go easy.
I have an activity db that I want to build a view to show Completed and Pending activities. Everything worked great until the users started entering future dates for projects. (Ex. ProjED 12/31/02.)
My initial way to determine pending vs. completed was the absence of an ProjED on the form. Now I need to determine if the ProjED is in the future or past before I can determine Pending vs. Completed.
I tried the following code, and received this message:
Comparison Operators must be supplied the same data type
Today := @Today;
PED := Project_End_Date;
@If(PED =< Today ; "Complete" ; "Pending"
I do not know how to proceed.
Can anyone help?
I have an activity db that I want to build a view to show Completed and Pending activities. Everything worked great until the users started entering future dates for projects. (Ex. ProjED 12/31/02.)
My initial way to determine pending vs. completed was the absence of an ProjED on the form. Now I need to determine if the ProjED is in the future or past before I can determine Pending vs. Completed.
I tried the following code, and received this message:
Comparison Operators must be supplied the same data type
Today := @Today;
PED := Project_End_Date;
@If(PED =< Today ; "Complete" ; "Pending"
I do not know how to proceed.
Can anyone help?