By using this website, you agree to our Terms of Use (click 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])))
