— The Forums are now read-only —
— All new activity now takes place here: —
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?
Thanks
Scott
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])))
By using this website, you agree to our Terms of Use (click here)
