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.
Jul 06, 2023
projectfun --
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.
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.
- projectfunJul 06, 2023Copper ContributorExcellent !
Thank you- Jul 06, 2023projectfun --
You are more than welcome, my friend! Thanks much for marking my reply as the answer to your question.