XModPro

Date formatting

David Hassall David Hassall asked Jan 4, 2018
Active Jan 4 · Viewed 2479 times
<p>Hi </p> <p>I can see that we can get UK (international) date formats using dd-MM-yyyy but I am wondering if the more expansive option are available e.g. </p> <p>for January 6 2018 </p> <p>default is 1/6/18 </p> <p>dd-mm-yy gives 06-01-18 </p> <p>I have tried other standard formats but get obscure results </p> <p>I'm looking for </p> <p>ddd dd MM yyyy to give Sat 06 01 2018 </p> <p>or even (very friendly) </p> <p>ddd d MMM yyyy to give Sat 6 Jan 2018 </p> <p>They are the more traditional format(getdate, "ddd d mmm yyyy") from Microsoft or even DATEPART and DATENAME in SQL </p> <p>Thanks </p> <p>Dave </p> <p><br> </p> <p><br> </p> <p><br> </p> <p><br> </p>

1 Answer

Loading answers...