Field1 is General Date Format - I'd like to query using the Date() Function
But that doesn't work.
I tried creating Field2 in a Short Date Format with a Short Date Input Mask and used VBA
Field2 = Field1
Planning to use the Date() Function to query Field2 and sort Field1
But that doesn't work either because the time part of Field1 transfers right across to Field2
Any idea or pointers on how to tackle this would be much apreciated.
But that doesn't work.
I tried creating Field2 in a Short Date Format with a Short Date Input Mask and used VBA
Field2 = Field1
Planning to use the Date() Function to query Field2 and sort Field1
But that doesn't work either because the time part of Field1 transfers right across to Field2
Any idea or pointers on how to tackle this would be much apreciated.