Forum Discussion

projectfun's avatar
projectfun
Copper Contributor
Jul 06, 2023
Solved

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...
  • Dale_HowardMVP's avatar
    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.

Resources