For John Spencer

O

Ofer

It is possible to write the format for date time as
=format([MyDate],"ddmmyyyyhhmmss")

Access still recognise the mm as minutes even though it's apear in the month
so you don't have to write the monutes with nn.
But I agrea that it should be the right way to write it that way

=format([MyDate],"ddmmyyyyhhnnss")

Thank you for your help
 
Top