Date field has incorrect entry (1 Viewer)

meridklt

New member
Local time
Today, 13:10
Joined
Dec 16, 2006
Messages
5
I mistakenly did not enter a date into thousands of records and so now in MySQL they display those dates as --

There is an option on the web site php page to remove all dates records by entering just the year, but it does not delete them if I enter --

Can anyone help please?

My grandad is very poorly in hospital and so I can't ask him and I know very little about MySQL or php.
 

isladogs

CID Moderator
Staff member
Local time
Today, 13:10
Joined
Jan 14, 2017
Messages
12,542
Not sure how Access will read dates with values -- so the following may not work
Assuming the MySQL table is linked to an Access database, try running an update query to replace all instances of -- with Null

Otherwise try something similar in MySQL itself
 

meridklt

New member
Local time
Today, 13:10
Joined
Dec 16, 2006
Messages
5
Thanks Colin.

I feel such a fool as my grandad's program has nothing to do with Access as its just MySQL with php for the web site and I will try the MySQL forum after trying out your MySQL suggestion if I can figure it out.

So I'm sorry for wasting everyone's time.
 

isladogs

CID Moderator
Staff member
Local time
Today, 13:10
Joined
Jan 14, 2017
Messages
12,542
No problem
I've moved it to the MySQL section of the forum but that's little used.
A specialist forum might indeed be better if my suggestion is no use
 

Gasman

Enthusiastic Amateur
Local time
Today, 13:10
Joined
Sep 21, 2011
Messages
5,075
Thanks Colin.

I feel such a fool as my grandad's program has nothing to do with Access as its just MySQL with php for the web site and I will try the MySQL forum after trying out your MySQL suggestion if I can figure it out.

So I'm sorry for wasting everyone's time.
No chance of rolling back to a backup?
 

meridklt

New member
Local time
Today, 13:10
Joined
Dec 16, 2006
Messages
5
My problem is resolved as I found rummaging around in MySQL I could in Search do a Find -- and Replace with 2019-06-08
 

isladogs

CID Moderator
Staff member
Local time
Today, 13:10
Joined
Jan 14, 2017
Messages
12,542
Excellent. Glad you got a solution
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom