-
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
Watch MrExcel Video
This Week's Hot Topics
-
Excel VBA Parse Column A into multiple columns help but with conditions
- Started by BalloutMoe
- Replies: 56
Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle... -
Data with Different score
- Started by sksanjeev786
- Replies: 30
Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data... -
Looping a macro through all visible sheets?
- Started by GlennJ
- Replies: 29
I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub... -
Loop through Column, looking for an array of values, If NOT found, delete entire row
- Started by blbat
- Replies: 29
So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find... -
VBA to extract values starting with specific character
- Started by sncb
- Replies: 21
Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start... -
macro/vba fix for not a blank, blank in Go To Special
- Started by LorettaAlsop
- Replies: 20
I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...
