`

Microsoft Access VBA Date Format 1st 2nd 3rd 4th

    博客分类:
  • VBA
阅读更多

 

sDate = Format(Date, "dddd dd") & 
Mid("thstndrdth", (DatePart("d", Date) Mod 10) * 2 + 1, 2) & " " & 
Format(Date, "mmmm yyyy")

Example - Saturday 21st August 2010

 

MonthName(3) 	would return 'March'
MonthName(3, TRUE) 	would return 'Mar'
MonthName(7, FALSE) 	would return 'July'

 

http://www.martintallett.com/st-nd-rd-th.html

http://www.techonthenet.com/excel/formulas/monthname.php

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics