Forum Discussion
projectfun
Jul 06, 2023Copper Contributor
Formula for CustomField which will check if date field [Start9] has a date entered - problem
Hi Team, Could you please help I have a problem with "simple" formula for custom field which will check if field [Start9] has a date or no For [Flag1] field I try following formula IIf(([St...
- Jul 06, 2023projectfun --
The easiest way to test if a default or custom field contains a date is to use the ProjDateValue function, such as in the following example:
IIf([Start9]=ProjDateValue("NA"),"No Date","Has a Date")
Hope this helps.
projectfun
Jul 06, 2023Copper Contributor
Excellent !
Thank you
Thank you
Jul 06, 2023
projectfun --
You are more than welcome, my friend! Thanks much for marking my reply as the answer to your question.
You are more than welcome, my friend! Thanks much for marking my reply as the answer to your question.