Date format - code to alter?

  • Thread starter Thread starter Dickie Black
  • Start date Start date
D

Dickie Black

Hi,

I've got an unbound combo box which produces a date in the format "dddd d mm
yyyy" eg Monday 4 November 2002.

I would like to use this value in a query, but i think the two sets of "d"
values are screwing things up.

I have tried using the expression "Format([DateBox], "dd-mm-yyyy") but this
does nothing.

I have also tried DateValue([DateBox]), but this gives me a type mismatch
error.

What code could I use to chop off the preceeding day value? (and leave, for
example 4 November 2002)

Thanks,

Dickie
 
Back
Top