Jump to content
Salesforce and other SMB Solutions are coming soon. ×

making calc field data static


Recommended Posts


An auto-enter calc for a static text field can deliver static info after a specified date.


Use the evaluate function, with the first parameter being an if statement comparing the current date to a deadline date field with the default return being the current content of the field.


[/ QUOTE ]


Good forum advice but I dunno how to implement it.


How do I pull current date into the Evaluate expression ?

How do I make the current content of a field the default value?



Link to comment
Share on other sites


In fact there is no need to use the Evaluate function for this.


If you define a text field with an auto-enter calc along the lines of:


If(Get(CurrentDate) > Date(5; 31; 2005); "Overdue")


- in records created prior to the end of May, the field will be blank, but after the end of May it will automatically acquire the default valud 'Overdue' on record creation.


Does that answer your questions?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use