These date things are making me want to cry
when I try to put this in query grid I get data type Mismatch error:
[MyDate] = Format(MyTestDate(),"\#mm\/dd\/yyyy\#")
if I put it like this it's work (give me 372 results)
Format([MyDate],"\#mm\/dd\/yyyy\#") = Format(MyTestDate(),"\#mm\/dd\/yyyy\#")
if I put it like this it's also work (but give me 236 results)
[MyDate] = MyTestDate()
both [MyDate] and MyTestDate() are dates
MyTestDate() read a saved public Date varaible
I have more problems now, when I try to use ConditionalFormat
If I use these it wont work:
[MyDate] <= Format(Date(),"\#mm\/dd\/yyyy\#")
Format([MyDate],"\#mm\/dd\/yyyy\#")<=Format(Date(),"\#mm\/dd\/yyyy\#")
This will work, but how can I be sure it will correctly identify the dates as dd/mm/yyyy:
[MyDate]<=Date()