| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using "dd/mm/yyyy h:mm" on Date Variables
I am calculating dates in a loop and using the following date format:
DateFormat = "dd/mm/yyyy h:mm" When I print to the Immediate Window, the first hour (hour ending 0) shows up without the h:mm extension. I expected to see: 01/01/2005 00:00:00. Why is this? Thanks CurrentDate = Format(DateSerial(CurrentYear, CurrentMonth, CurrentDay), DateFormat) Debug.Print CurrentDate CurrentDate = Format(CurrentDate + 1 / 24, DateFormat) Debug.Print CurrentDate Immediate Window: 01/01/2005 01/01/2005 01:00:00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change "xxx CR" and "y,yyy DB" to "+xxx" and "-yyyy" | Excel Worksheet Functions | |||
| Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
| Option Explicit and Date Format "dd mmm yyyy"? | Excel Programming | |||
| TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
| TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
Threaded Mode
