Getting Type mismatch:’formatDateTime’ error

[TrailblazerLS]

It works on some computers and some it does not? One of the sites we work with have a testing room with 17 computers and all of a sudden this error comes up on one of our apps, but it works fine on other computers in the room and throughout the building. Any ideas?

 

[Zion7]

TBLS, with such little info to go on,
I can only assume it's a string to Date type issue?

Using the format(), changes all data types into strings.
are you trying to format a string into a Date type?

in order to reconvert, use one of the many conversion functions.

dteDate As Date
dteDate = #12/1/2006#
dteDate = Format(dteDate,"mm/dd/yy")'errors here???

possibly
dteDate = CDate(Format(dteDate,"mm/dd/yy"))?