Problem about buddhist era data

[zugapy]

This is my data form;input buddhist era data

When press "Add to history button"


by command:
sql = "INSERT INTO [History] (AssetID, AssetCategoryID, EmployeeID, DateBorrowed,

DateReturned) " _
& "VALUES (" & Me.AssetID.Value & ", " & Me.AssetCategoryID.Value & ", " &


Me.EmployeeID.Value & ", #" & DateValue(Me.DateBorrowed) & "#, #" & DateValue


(DateReturned) & "#)"

A result is


The result at above is not correct(3100) because it should be 2557.

Anyone,help me please.

Thanks

[June7]

Are those date values going into text fields? Why using DateValue function? If those are text fields then don't try to save date values. Just save the text string.

& ", '" & Me.DateBorrowed & "', '" & DateReturned & "')"

[zugapy]

Are those date values going into text fields? Why using DateValue function? If those are text fields then don't try to save date values. Just save the text string.

& ", '" & Me.DateBorrowed & "', '" & DateReturned & "')"

Thank you.