5 Digits Date to Normal Date Format

**cyliyu** · 02-12-2022, 09:49 PM

Is there a formula I can use to convert a 5-digit date to a standard date format?

**June7** · 02-12-2022, 09:56 PM

Why only 5 digits? Show examples.

Maybe: CDate(5digits)

**cyliyu** · 02-13-2022, 01:22 AM

Originally Posted by June7

Why only 5 digits? Show examples.

Maybe: CDate(5digits)

It was because of the data type, however, I'd like to see whether there's a formula to convert back to date.

Click image for larger version.

Name: Capture.JPG
Views: 21
Size: 24.6 KB
ID: 47262

**June7** · 02-13-2022, 03:14 AM

What do you mean 'because of the data type'? Was this imported from Excel? Did you try the suggestion? Calculate in query or textbox.

If you want to change data in table, can:

1. first run an update action SQL
UPDATE tablename SET fieldname = CDate(fieldname);

2. now change field type to date/time

**Welshgasman** · 02-13-2022, 05:37 AM

Originally Posted by cyliyu

It was because of the data type, however, I'd like to see whether there's a formula to convert back to date.

They appear to already be dates?, just the true numeric value?

**mike60smart** · 02-13-2022, 06:00 AM

Hi

Looks like the data has been imported or copied from Excel.

The field in the table just needs to be changed from Text to DateTime

**June7** · 02-13-2022, 12:55 PM

I tested just changing text to datetime and it failed. Try it yourself.

The two-step method tested and worked.

**mike60smart** · 02-13-2022, 01:05 PM

Hi June

I believe you.

5 Digits Date to Normal Date Format

Thread Tools

5 Digits Date to Normal Date Format

Similar Threads

I need to convert a date result in a query to UK format date

Convert Customs System Date or Normal Date MM/DD/YYYY

sintax for formatting date to normal date in a query expression field

MS Access 2013 Bug : Button Format Style Change back to normal format after Saving db with diff name

I've a date and time format as mentioned below. I want to add +6:30 to it and then extract date

Posting Permissions