Reply to comment

Date Format

Hello there, 

I just want to share this to you guys this is actually what I did when I want to have this format e.g. 20 August, 2012

Right("0" & Day(ToDate([Date Created])), 2)& "&nbsp" & Case(Month(ToDate([Date Created])),1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,
"August",9,"September",10,"October",11,"November",12,"December" ) & "," & Year
(ToDate([Date Created]))

I hope it can help the other people solving their problem when it comes to date.

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit