... referring to converting strings to dates and incorrect data types.
How?
The fix is to simply get the field and both results to be of the same data type:
=IIF(CStr(Fields!MyCompletionTime.Value)"", ...
... Date (european format - dd/mm/yyyy)
=CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now())))
-- To Date (european format - dd/mm/yyyy)
=dateadd("d",-1, CDate("01/" + cstr(month(today.now())+1) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.