Date yyyy\/mm\/dd\/ nn explanation

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
1,302
Hi All

I have seen people date and time format like something above. can someone please explain how this works and correct syntax to get date time for Uk format ... ie

03/05 thats 3rd of May and not 5th of March
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
577
Office Version
2013
Platform
Windows
Forget about the sequence within your topic (yyyy\/mm\/dd\/ nn) it's used in SQL strings.
You're able to show a date in any format you like.
VBA Code:
Sub Example()
    MsgBox Format(Date, "dd-mm-yyyy") & vbCrLf & _
           Format(Date, "dddd dd mmm yyyy")
End Sub
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,042
Office Version
365
Platform
Windows
Forget about the sequence within your topic (yyyy\/mm\/dd\/ nn) it's used in SQL strings.
This question is actually posted in the Access forum (not the Excel one), and Access uses a version of SQL.
 

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
1,302
Thank you - still dont know how and why to use it in that format especially \/ and nn :)
 

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
577
Office Version
2013
Platform
Windows
This question is actually posted in the Access forum (not the Excel one), and Access uses a version of SQL.
Apologies, I wasn't aware of that (and don't have any Access skills)

Thank you - still dont know how and why to use it in that format especially \/ and nn :)
From an interest I read a lot about computers, programming and security stuff (eg back doors, memory leaks, abuse of unintended weaknesses). Once I read an article about SQL injection and the use of backslashes in query messages (and ways for data manipulation). When I saw your topic headline I immediately thought of that, in my opinion it would be of no interest to an Excel user. I didn't notice I was reading a question in the Access forum.
Some googling brought me here, this might be of some use. Access VBA & SQL date formats
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,042
Office Version
365
Platform
Windows
I didn't notice I was reading a question in the Access forum.
Yeah, a lot of people are unaware that the "Unanswered Questions" listing is not just for the Excel Questions forums, but all the Questions Forums.
Underneath the title, in gray type, it tells you which forum each question is found under.
On the old board, it was even harder to notice, as the forum was all the way over on the right side by itself.
 

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
577
Office Version
2013
Platform
Windows
Thank you for pointing me out (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,728
Messages
5,446,174
Members
405,389
Latest member
Excel n00b2

This Week's Hot Topics

Top