[belajar-access] format date

Wed, 14 Apr 2010 15:15:03 -0700 

para pendekar access...

sintaks 1 :
            lddate = Format(Date, "dd-mmm-yyyy")
            DoCmd.RunSQL "update client set verify_date=" & lddate & ", 
verify_by='" & pcUserNameLogin & "' where client_id=" & Me.Client_Id.Value

sintaks 2 ;
            lddate = date
            DoCmd.RunSQL "update client set verify_date=" & lddate & ", 
verify_by='" & pcUserNameLogin & "' where client_id=" & Me.Client_Id.Value


kenapa dua2nya untuk variable lddate menghasilkan : 12:00:12 AM   

bagaimana supaya  tampil  : 4/14/2010
kenapa bisa beda dengan dari textbox diform ya?

Send instant messages to your online friends http://uk.messenger.yahoo.com

Kirim email ke