Haven't seen any forum bugs today other than a very slow response time that has gotten worse over the past few months.
Are you trying to set up a script step or a calculation? Your syntax is a mix of the two.
As a calculation you'd do this:
If (endDate > Get ( CurrentDate ) ;"UNAVAILABLE" ; "Available to Place")
As a script step:
IF [endDate > Get ( CurrentDate )]
Set Field [ YourTable::field ; "UNAVAILABLE" ]
Set Field [ YourTable::Field ; "Available to Place" ]
Yup! That worked, thanks.
I have another question, if I may. I have a portal set up in a TAB window on the layout. The records in the portal are SORTED by DATE field. The most current date first. If I run this script on Layout Entry, will it look at the most current record or do I have to add another calculation?
Thanks again, for your help, Phil!
Barring any code that sets the focus in a portal row, any reference to a field from a related table will reference the first record in an UNSORTED portal. Sorting the portal as a setting in portal set up will not affect this.
But you can instead, open up Manage | Database | Relationships, double click the relationship line and then sort the Relationship instead of the portal in order to make the most current date the first related record.
Nice, I will try that, thanks!! As always, greatly appreciated! :)
Worked like a charm!! THANKS! :)