CODEWITHSUNDEEP
sqlms-access
user2096512
user2096512

Reputation: 469

Access date format

I'm having trouble copying a date field from one table to another in Access, the date format in my tables is showing as 23/08/2019 (23rd August). Usually I pull data into a VB.NET application, process it then insert it back into the DB, when I do this I use a function to convert the date into American format 08/23/2019 and it works fine, but I'm trying to copy the date into another table just using SQL and it puts it the wrong way around:

INSERT INTO Bets (rdate, track, horse, odds) 
SELECT rdate, track, horse, odds
FROM Selections;

This is odd as even though it shows the UK format in original table, it still works correctly, I.E. records with date 02/01/2019 would appear when selecting records for January 2019, but copying it to another table in this format makes it backwards.

Upvotes: 0

Views: 72

Answers (1)

Gustav
Gustav

Reputation: 55806

There is nothing to "convert".

You are mixing up the date value and the display format. The value is what matters, the format is for display only.

If you don't apply a specific format when listing the values, a default format is applied.

Upvotes: 2

Related Questions