What is yyyymmddhh24miss format

In contrast, philz's InvFormattime is more flexible for the programmer, though not for the end user. No problem; I'll send you the bill for the hours I've wasted doubting myself, as well as for the time I've spent on the Shrink Hotline. Thanks for the quick response, Titan - it works perfectly now!

I'm still an agnostic, if that's what you mean The studies are coming along nicely; I'll be done soon ish - and ready to join the Real World. I hope it's ok that I put this here; somehow if I understood any of this thread about dates I probably would not need to ask this at all. I want to select the date field in an Outlook Task, collect the date into a variable?

For information on time calculations, see EnvAdd and EnvSub that's stuff for another thread though. Just curious My thanks to you both. Titan, thanks too for having contributed that; I'll be sure to put the license stuff you mentioned in my script. Thanks again! Back to Scripts and Functions.

Reply to quoted posts Clear. Register now! Username or email:. I've forgotten my password Forum Password. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Enterprise Software. Thank you. If Format contains date and time elements together, they must not be intermixed.

In other words, the string should be dividable into two halves: a time half and a date half. For example, a format string consisting of "hh yyyy mm" would not produce the expected result because it has a date element in between two time elements.

When Format contains a numeric day of the month either d or dd followed by the full month name MMMM , the genitive form of the month name is used if the language has a genitive form. On a related note, addition, subtraction and comparison of dates and times can be performed with DateAdd and DateDiff.

Converts the specified number of seconds into the corresponding number of hours, minutes, and seconds hh:mm:ss format. Demonstrates different usages. Changes the date-time stamp of a file. MsgBox "The selected file was last modified at " FileTime.

Leave Format blank to produce the time followed by the long date.