Solved

How do I get a Valid YYYY/MM/DD HH24:MM:SS Value when using  the DTPicker's CustomFormat YYY/MM/DD HH:MM:SS

Posted on 2003-11-25
4
1,760 Views
Last Modified: 2013-12-26
Dear All:
      when using the DTPicker's CustomFormat(YYYY/MM/DD HH:MM:SS) to get a Date & Time Picker Functionality,the value show in the  Date Part and time part seems not right.what should i do if  I want to get a Valid Date Part & Time Part?
0
Comment
Question by:cancyjimmy
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 25 total points
ID: 9823261
yyy/MM/dd HH:mm:ss
0
 

Assisted Solution

by:BC8
BC8 earned 25 total points
ID: 9823272
Use yyyy/MM/dd hh:mm:ss.  Use HH for 24 hour time.
0
 

Author Comment

by:cancyjimmy
ID: 9823364
Dear GrahamSkan & BC8:
      I Try the format [yyy/MM/dd HH:mm:ss] & [yyyy/MM/dd hh:mm:ss] .That's Working Ok Now!
      Thank You!
      But I Wonder ,Why can i get difference between the format of UpperCase(MM|HH) and LowerCase (MM|HH)  ?
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 9823510
The format string is case-sensitive by design. hh has a different meaning to HH. MM refers to months. mm means minutes. YYYY is not understood at all, etc.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vb.net 2008 2 59
VBA: Personal Macro Retain/Highlight/Remove values in a selected column 4 30
VB6 ListBox Question 4 44
backup program with robocopy 6 18
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question