-
Hi all,
I have an access table and one of the field is entrydate (date and time is the datatype) field. I have customer id also.
For everyday transaction I need to know whether the customer is calling for second time.
I created query select * from [table name] where customer_id = '" & txtcid & "' and
*****(entrydate) = #'" & Date & "'#
ie. I am referring the date as the system date.
Now my porblem is how to convert the database [date and time ] field into a date
for my query .
anyone help me please
My advance thanks.
karun
-
Hai all,
I had found the way for my problem.
I used datevalue function which is quiet ok for my problem.
Anyway thanks for listening.
Thanks
karun
-
Try usign the Format function to format the date accordingly.
;-)
-
Hai Jaspal,
Format Function is giving syntax error.i am not able to use it.
it is giving error on the double quotes of the format function.
thanks
karun
-
Compare CInt(Date) to CInt(recordset.datefield) to see if there's a match.
-
Hai JHausmann,
I think you may understood my problem in a different way. My problem is how to format a date&time database field into a date to put in a search query.
I solved it using datevalue function.It works fine.
Anyway thanks a lot for your response.
Have a nice day
Karun
