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: 21
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: 75,505
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: 21
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: 75,505
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: 21
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,548
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: 75,505
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: 21
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
 


Custom Search


RSSSearch   Top   Lo-Fi    15th June 2019 - 10:16 PM