[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

fomat date

Posted on 2004-09-21
3
Medium Priority
?
258 Views
Last Modified: 2010-04-23
how can I format dates to  return ISO format "yyyy-mm-dd hh:mm:ss" ?

i have a string   sData = '#5/17/2001 9:37:00 AM#'
0
Comment
Question by:testn1
  • 2
3 Comments
 

Author Comment

by:testn1
ID: 12114742
or   sData = '#5/17/2001#'
0
 
LVL 10

Accepted Solution

by:
Clif earned 2000 total points
ID: 12114820
Format(sData, "yyyy-MM-dd HH:mm:ss")
0
 
LVL 10

Expert Comment

by:Clif
ID: 12114846
Oops, I missed the sData (which I presume means it's a string):

Format(CDate(sData), "yyyy-MM-dd HH:mm:ss")
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses
Course of the Month9 days, 5 hours left to enroll

590 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