WeekdayAdd used with IF function
Hi, I'm using the below formula in a field called [Due in OTMM] to return the date of the field [To MRC] with the addition of 5 business days: WeekdayAdd(ToDate([To MRC]),5) But what I'd real...
Forum Discussion
you wwre super close. se nhow you are saying to make a text empty field at the end?
,"")
well this is a date field so text is not allowed even empty text.
so use either null or else just be silent.
If (
[To MRC]>[From MRC],WeekdayAdd(ToDate([To MRC]),5),
[To OTMM]>[Date Imported],WeekdayAdd(ToDate([To OTMM]),2),
"")
so either thois
If (
[To MRC]>[From MRC],WeekdayAdd(ToDate([To MRC]),5),
[To OTMM]>[Date Imported],WeekdayAdd(ToDate([To OTMM]),2), null)
or else
If (
[To MRC]>[From MRC],WeekdayAdd(ToDate([To MRC]),5),
[To OTMM]>[Date Imported],WeekdayAdd(ToDate([To OTMM]),2))
,"")
well this is a date field so text is not allowed even empty text.
so use either null or else just be silent.
If (
[To MRC]>[From MRC],WeekdayAdd(ToDate([To MRC]),5),
[To OTMM]>[Date Imported],WeekdayAdd(ToDate([To OTMM]),2),
"")
so either thois
If (
[To MRC]>[From MRC],WeekdayAdd(ToDate([To MRC]),5),
[To OTMM]>[Date Imported],WeekdayAdd(ToDate([To OTMM]),2), null)
or else
If (
[To MRC]>[From MRC],WeekdayAdd(ToDate([To MRC]),5),
[To OTMM]>[Date Imported],WeekdayAdd(ToDate([To OTMM]),2))