VBScript How can I Format Date?

by 
0 = vbGeneralDate - Default. Returns date: mm/dd/yy and time if specified: hh:mm:ss PM/AM.
1 = vbLongDate - Returns date: weekday, monthname, year
2 = vbShortDate - Returns date: mm/dd/yy
3 = vbLongTime - Returns time: hh:mm:ss PM/AM
4 = vbShortTime - Return time: hh:mm


d=CDate("2010-02-16 13:45")
document.write(FormatDateTime(d) & "<br />")
document.write(FormatDateTime(d,1) & "<br />")
document.write(FormatDateTime(d,2) & "<br />")
document.write(FormatDateTime(d,3) & "<br />")
document.write(FormatDateTime(d,4) & "<br />")

If you want to use another format you will have to create your own function and parse Month, Year, Day, etc and put them together in your preferred format.

Function myDateFormat(myDate)
    d = TwoDigits(Day(myDate))
    m = TwoDigits(Month(myDate))    
    y = Year(myDate)
    myDateFormat= m & "-" & d & "-" & y
End Function

Function TwoDigits(num)
    If(Len(num)=1) Then
        TwoDigits="0"&num
    Else
        TwoDigits=num
    End If
End Function

edit: added function to format day and month as 0n if value is less than 10.

More Related Contents:

  1. Change date format as dd/mm/yyyy in php [closed]
  2. How can I parse / create a date time stamp formatted with fractional seconds UTC timezone (ISO 8601, RFC 3339) in Swift?
  3. Parsing RFC-3339 / ISO-8601 date-time string in Go
  4. `uuuu` versus `yyyy` in `DateTimeFormatter` formatting pattern codes in Java?
  5. group by dates in mongodb
  6. Format date as dd/MM/yyyy using pipes
  7. How to convert milliseconds into human readable form?
  8. Zero-based month numbering [closed]
  9. Is it always a good idea to store time in UTC or is this the case where storing in local time is better?
  10. Date does not display from Model on HTML input type date
  11. How to convert ISO Date to UTC date in Hive
  12. Google Apps Script date format issue (Utilities.formatDate)
  13. Determine season given timestamp in Python using datetime
  14. Difference between two dates expressed as years, months, days (in one column)
  15. How to compare dates or date against today with query on google sheets?
  16. Date arithmetic in cmd scripting
  17. Changing date format to “%d/%m/%Y”
  18. breezejs: date is not set to the right time
  19. Compare two dates Google apps script
  20. How do I align date and values to gridlines in Google Chart?
  21. Carbon Difference in Time between two Dates in hh:mm:ss format
  22. Same date in different time zone
  23. What is the precise definition of JDE’s Julian Date format?
  24. Error ASP 0177: 8007007e CreateObject fails for COM DLL
  25. Read utf-8 text file in vbscript
  26. How to count days between two dates in PHP?
  27. PHP date – get name of the months in local language
  28. Check whether string is a date Postgresql
  29. Why can’t OffsetDateTime parse ‘2016-08-24T18:38:05.507+0000’ in Java 8
  30. Get date for monday and friday for the current week (PHP)

Leave a Comment