Date time in Textbox problem

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello:

I have an untyped dataset that uses an Access 2002 database.

For every record, it shows mm/dd/yyyy 12:00:00 AM in the textbox.

All I want to show is mm/dd/yyyy

I don't even know where it's getting the 12:00:00 AM from. I checked the raw
data in the table and only a short date is in each field but my app keeps
appending that 12:00:00 AM to every record.

I read many posts and I did change my type to Date instead of DateTime in
the parameter collection and Schema but to no avail.

TIA

Bob
 
i think that the dataset is complating the time, and always complete it with
12:00:00 AM by default...

try to make an format(field,"mm-dd-yyyy") this way you force it to put it
so...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with query dates 4
separating date and time 5
Date time format 3
Access Access 2010 - Date()-1 and times in query 0
Getting MM-DD HH:MM out of Julian date 4
Access General Date Forced To Have Date And Time 2
ASP.NET web application - date conversions UK date format? 7
date conversion problem 4

Back
Top