UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Date Data Type Changed To Numbers, Access 2007    
 
   
Flacon88
post Jun 13 2019, 03:12 PM
Post#1



Posts: 30
Joined: 17-November 18



Hiii all

I have a field on a form its data type is date, its dafault value is system date, today when add new record to that form i surprised the date field is numbers (no date ).

Note ; the system date is right .

Please help.
Go to the top of the page
 
theDBguy
post Jun 13 2019, 03:13 PM
Post#2


Access Wiki and Forums Moderator
Posts: 76,000
Joined: 19-June 07
From: SunnySandyEggo


Hi. You said "form." What is the data type in the table?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Flacon88
post Jun 13 2019, 03:25 PM
Post#3



Posts: 30
Joined: 17-November 18



Table has :

VisitID: Long (Pk)
VisitDate: date/time (the field that changet to numbers ).
DoctorRefer: text.
Go to the top of the page
 
theDBguy
post Jun 13 2019, 03:37 PM
Post#4


Access Wiki and Forums Moderator
Posts: 76,000
Joined: 19-June 07
From: SunnySandyEggo


Well, dates are just numbers anyway. So, when you said it changed to numbers, is this by looking at the values in the table?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Flacon88
post Jun 13 2019, 03:46 PM
Post#5



Posts: 30
Joined: 17-November 18



No, this appears on the form .

I don't looking to the table .
Go to the top of the page
 
WildBird
post Jun 13 2019, 03:50 PM
Post#6


UtterAccess VIP
Posts: 3,594
Joined: 19-August 03
From: Auckland, Little Australia


Can you show what numbers they are showing? Screenshots help.

Is the number something close to 43630 by any chance?

--------------------
Beer, natures brain defragging tool.
Go to the top of the page
 
theDBguy
post Jun 13 2019, 03:52 PM
Post#7


Access Wiki and Forums Moderator
Posts: 76,000
Joined: 19-June 07
From: SunnySandyEggo


If only on the form, then perhaps you just need to set/select the proper Format for it. But, if you look at the table, do you see dates or numbers?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Flacon88
post Jun 13 2019, 04:03 PM
Post#8



Posts: 30
Joined: 17-November 18



This is not able this time.

But i thinking numbers is like you reply.

Note: the db is in accde format
Go to the top of the page
 
Flacon88
post Jun 16 2019, 10:07 PM
Post#9



Posts: 30
Joined: 17-November 18



See to visit date :


Attached File(s)
Attached File  Screenshot_2019_06_17_06_03_36.png ( 379.23K )Number of downloads: 2
 
Go to the top of the page
 
MadPiet
post Jun 16 2019, 10:17 PM
Post#10



Posts: 3,206
Joined: 27-February 09



That's a form, not a table. =) The problem with showing a form is that it allows you to change the way the data in the table is represented, and folks here are trying to see past that. And dates/times are stored as numbers under the covers anyway. The integer portion is the number of days since some date in 1752 (I think) and then the decimal portion is the time.
Go to the top of the page
 
gemmathehusky
post Jun 17 2019, 04:14 AM
Post#11


UtterAccess VIP
Posts: 4,725
Joined: 5-June 07
From: UK


what IS 15,6,19166

It's not a valid date. Is there a regional setting that allows commas as date separators? Even so, the year can't be right, and the month would have a leading zero.

What is the format and data source of the control on your form - it's hard to see how that entry can have been accepted in the table as a valid date.

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 
moke123
post Jun 17 2019, 05:24 AM
Post#12



Posts: 1,362
Joined: 26-December 12
From: Berkshire Mtns.


QUOTE
Note: the db is in accde format

Do you have the Accdb file?
You wont be able to make any changes\Repairs to an Accde file.

Go to the top of the page
 
Flacon88
post Jun 17 2019, 07:39 AM
Post#13



Posts: 30
Joined: 17-November 18



The day and month parts of that field is right, the problem at the year part.

Note: the date format is (dd/mm/yyyy).
Go to the top of the page
 
cheekybuddha
post Jun 17 2019, 07:56 AM
Post#14


UtterAccess VIP
Posts: 11,462
Joined: 6-December 03
From: Telegraph Hill


Somewhere you have an incorrect format set - hopefully on the textbox.

It looks like a format: "dd,mm,yyddm"

With the form in design view, select the textbox. In the properties dialog look at the Format section under the Format tab, and also the Text Format section under the Data tab

Does it say anything in either of those places?

Also look at your table in design view. Select your date field and look in the Field Properties section. Is there anything in the Format section of the General tab?

If not, then perhaps the regional setting for your dates on your machine have been changed to use an incorrect format string.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
Flacon88
post Jun 17 2019, 08:32 AM
Post#15



Posts: 30
Joined: 17-November 18



QUOTE
Somewhere you have an incorrect format set - hopefully on the textbox.

It looks like a format: "dd,mm,yyddm"

With the form in design view, select the textbox. In the properties dialog look at theFormat section under the Format tab, and also the Text Format section under the Data tab

Does it say anything in either of those places?

Also look at your table in design view. Select your date field and look in the Field Properties section. Is there anything in the Formatsection of the General tab?

If not, then perhaps the regional setting for your dates on your machine have been changed to use an incorrect format string.


Thanks for all.

The visitdate field is a date/time data type, and format is dd\mm\yyyy , and user uses this database for more than one year without any problem , Suddenly this problem only appeared four days ago.
Go to the top of the page
 
cheekybuddha
post Jun 17 2019, 08:57 AM
Post#16


UtterAccess VIP
Posts: 11,462
Joined: 6-December 03
From: Telegraph Hill


So did you look in the other places I suggested?

--------------------


Regards,

David Marten
Go to the top of the page
 
gemmathehusky
post Jun 17 2019, 11:14 AM
Post#17


UtterAccess VIP
Posts: 4,725
Joined: 5-June 07
From: UK


QUOTE
The day and month parts of that field is right, the problem at the year part.

Note: the date format is (dd/mm/yyyy).



Sorry, it just isn't right. A month would show as 06, not just 6, and you probably wouldn't see 19/06/19166

We need to know the field that is bound to the text box control VISIT DATE, and the format applied to VISIT DATE

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 
RJD
post Jun 17 2019, 11:42 AM
Post#18


UtterAccess VIP
Posts: 9,913
Joined: 25-October 10
From: Gulf South USA


Hi: Pardon me for jumping in, but since we do not have your db to work with, we are left in the dark guessing.

I ran a quick test using several different mistakes in a Format for the year - and it looks like you might have formatted the date as ...

"dd/mm/yyy"

... the year as 3 y's rather than 4, resulting in year 19168 (for today's date, almost what you saw)... without showing an error.

So, if you can, check the format for the date (both in the table and the form) and see if it might simply be typed incorrectly.

Just some thoughts ...

HTH
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    19th August 2019 - 05:15 AM