ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   DATE FORMAT issue (https://www.excelbanter.com/excel-worksheet-functions/70248-date-format-issue.html)

[email protected]

DATE FORMAT issue
 
I have a piece of code like this:

Now() which returns the correct value of 2006/02/08 08:18:41 (with my
last test)

now if I run the following:

Format(Now, "mmm") that brings Jan

any ideas why?


[email protected]

DATE FORMAT issue
 
never mind...solved it...the Month() was throwing it off

Format(now,"mmm") works fine...



All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com