Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel VBA - Convert Date format
Worksheets("Utdata").Range("A1").Offset(r, 0).Value = "<InvoiceDate>" & Format(fldInvoiceDate.Value, "YYYY-MM-DD") & "</InvoiceDate>" The code above did it! Based on your help, I didn't need the InvoiceDate variable. Skip: I see your point in your last message. As the output of my macro is a...- CDebet
- Post #9
- Forum: Microsoft: Office
-
Excel VBA - Convert Date format
The date is entered by the user through a text field in a form, and is in the end used in an xml-file. The logic for the application that in turn will read this file, expects a "YYYY-MM-DD"-format. The way I see it, conversion can be done in two ways: 1) Assign the date-field value in the form...- CDebet
- Post #4
- Forum: Microsoft: Office
-
Excel VBA - Convert Date format
Hi, System date format is "DD/MM-YYYY". I need to output a date format like "YYYY-MM-DD". Without changing system date format, but within the macro, how can I convert the present "DD/MM/YYYY" to "YYYY-MM-DD" In advance thanks! CDebet- CDebet
- Thread
- Replies: 8
- Forum: Microsoft: Office
