Results 1 to 1 of 1
2005-05-17, 01:50 #1
- Join Date
- Feb 2001
- Yilgarn region of Toronto, Ontario
- Thanked 0 Times in 0 Posts
DateSerial/TimeSerial too lenient ? (Word XP)
VBA for both functions state "When any argument exceeds the normal range for that argument, it increments to the next larger unit as appropriate".
You can trip an error with values outside the range -32,768 to 32,767, but it seems to me that when one is parsing a date/time string from a character string, such as that produced by Format NOW(),"YYYYMMDD") or Format NOW(),"HHMMSS"), it behoves the programmer to monitor user input. In this case I'm parsing a date/time string within a user's file name.