Hello

I'm using this function:
------------------------------------
Public Function OracleDate(InDate As Date) As String
OracleDate = "To_Date('" & Format(InDate, "dd-mm-yyyy") & "','DD-MON-YYYY')"
End Function

* Refer from book
------------------------------------

It come to a little bit confusion to use it when i started to update
My command:
-----------------------------------
rs1.Addnew
rs1!EOQ = Val(T_EOQ.Text)
rs1!BATCHNO = T_Batchno.Text
rs1!UserName = Label1(3).Caption
rs1!DateLog = OracleDate(InDate)'also error with (To_Date)
rs1.update
-----------------------------------
Problem appear as Variable not Define

Please help me, TQ.


------------------
Khamal

[This message has been edited by khamal (edited 12-24-1999).]