Is there a formula I can use to convert a 5-digit date to a standard date format?
Is there a formula I can use to convert a 5-digit date to a standard date format?
Why only 5 digits? Show examples.
Maybe: CDate(5digits)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
I tested just changing text to datetime and it failed. Try it yourself.
The two-step method tested and worked.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi June
I believe you.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description