Correct saving my date

Question

I have a table which has four fields in ms access

Oid(Number) Odate(Date) Dr(Number) Cr(Number)

Req(Yes) Req(Yes) Req(No) Req(No)

I use two Forms to add record and edit record

When I add a record with the date 01/10/2012. It will save as dd/mm/yy Format

When I modify to enter odate and oid it will retrieve it but when I save.

After save again I want to edit agian this entry but it is not matching the record because

It has been saved before in the format mm/dd/yy

Please help me again this problem

Anurag Maurya · Answer

When you apply a custom format to the Date/Time field you can combine different formats by having two sections one for the date and another for the time. In such an instance you would separate the sections with a semicolon. For example you can combine the General Date and Long Time formats as follows: m/dd/yyyy;h:mm:ss. In the Navigation Pane right-click the table that you want to work with and then click Design View . In the upper section of the design grid select the Date/Time field you want to format. In the lower section click the Format property box and then enter your format. So if you use '30/09/2008' it will recognize you're using dd/mm/yyyy and convert it appropriately. However a value like '10/01/2008' is a valid mm/dd/yyyy value to begin with so it will not be converted and stored incorrectly in case you actually meant dd/mm/yyyy....

Ehtesham · Answer

can you post the code?