Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Date Manipulation
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Date Manipulation
Resolved · High Priority · Version 2003
Reply Thu 23 Jun 2011, 16:10Delegate Michael said...
Michael has attended:
Excel VBA Advanced course
Date Manipulation
Is there a ready macro to check the format of the date, and if in US format, convert into British date format? Thanks
For upcoming training course dates see: Pricing & availability
RE: Date Manipulation
Hi Michael
Thanks for the question. The following function chops up the date into day, month and year and then arranges it into UK format
Public Function DateConverter(USDate As String) As Date
Dim strMonth As String
Dim strDay As String
Dim strYear As String
Dim strDate As String
strDay = DatePart("d", USDate)
strMonth = DatePart("m", USDate)
strYear = DatePart("yyyy", USDate)
strDate = strDay & "/" & strMonth & "/" & strYear
DateConverter = CDate(strDate)
End Function
I hope this helps
Stephen
Thu 30 Jun 2011: Automatically marked as resolved.
|