By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,420 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,420 IT Pros & Developers. It's quick & easy.

Date time in Textbox problem

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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...

"Bob" wrote:
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.