In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions The expression contains a call of an undefined function DateAdd()
I'm getting this error message in report designer on the following expression. DateAdd is listed as an available function.
I currently have the expression in a variable, but I was also getting the error when I embed the DateAdd funtion in a larger expression.
(note: field names are part of a third party customization)
=DateAdd([FSSOEmployee.UsrIGAHWeekDay],'h', DateDiff('h', [FSSOEmployee.UsrIGAHWeekDay], [FSSOEmployee.UsrIGAHStartTime]))
Any ideas? Am I missing something obvious?
Scott, I have had to convert the "dates" in the function by using the CDate ()
Something like =DateAdd(CDate([FSSOEmployee.UsrIGAHWeekDay]),'h', DateDiff('h', CDate([FSSOEmployee.UsrIGAHWeekDay]), CDate([FSSOEmployee.UsrIGAHStartTime])))