Hello,
I have a little problem regarding VB code, i have a field in Access database which is a Date field with format "Medium Date" e.g: 17-May-06. Now in my code i am searching a record with the same Date. I have given Calendar where user picks the date but the problem is that with the selected date time is also displayed e.g- 5/17/06 12:00 AM. So although i have the record mathching the date the query is unable to get the record.
How can i set the date so that no time is displayed with it and also the date is displayed in format (17-May-06)
Any idea Please help asap!!!!!!
I have a little problem regarding VB code, i have a field in Access database which is a Date field with format "Medium Date" e.g: 17-May-06. Now in my code i am searching a record with the same Date. I have given Calendar where user picks the date but the problem is that with the selected date time is also displayed e.g- 5/17/06 12:00 AM. So although i have the record mathching the date the query is unable to get the record.
How can i set the date so that no time is displayed with it and also the date is displayed in format (17-May-06)
Any idea Please help asap!!!!!!
