-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
date time format
-
R
Trouble Importing Date Time Field in Access 2013
The SQL below returns the field ‘TABLE.LAST_DTTM_UPDATE’ in this format: 'YYYY-MM-DD-HH24.MI.SS.FF'. Example field value: 01/14/2016 1:36:36PM Unfortunately, I don’t have any way to change this format within the SQL. When I try to import the data into a new table of an Access 2013 database...- RHONDAK72
- Thread
- access 2013 date time format
- Replies: 0
- Forum: Microsoft Access
-
P
converting a strange date/time value into a recognisable date-time format
Hi all. I have a column (say col A) that has values in the format yyyy-mm-ddThh_mm_ss. I decided to create the function below to convert them to dd/mm/yyyy hh:mm:ss in column B. However I'm getting a #Name? error. I'm not exactly a VBA proficient and I would like your opinion about where it is...- plusunim
- Thread
- date time format
- Replies: 4
- Forum: Excel Questions
-
J
Converting Dates To Different Formats
I'm trying to convert a column of dates from the date format of Monday, September 20, 2010 06:15 A.M. (cells are formatted as a DATE with English as the Language) to 2010-09-20 06:15:00 I tried the date formats for different languages. The closest I got was either Danish or Swedish. But...- jjexcel28
- Thread
- date time conversion date time format
- Replies: 2
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
