AutoHotkey Community

[Titan]

This function converts almost any date format to a YYYYMMDDHH24MISS value.
Inspired by philz InvFormattime.

e.g. time := DateParse("2:35 PM, 27 November 2007")
It will also work with any of the following formats: 4:55 am Feb 27, 2004; 11:26 PM; 1532; 19/2/05; 2007-06-26T14:09:12Z.

Download
_________________

RegExReplace("irc.freenode.net/autohotkey", "^(?=(.(?=[\0-r\[]*((?<=\.).))))(?:[c-\x73]{2,8}(\S))+((2)|\b[^\2-]){2}\D++$", "$u3$1$3$4$2")

[Chris]

Great work. I've linked to this topic from the FormatTime page. Its "Related" section now says, "To convert in the reverse direction -- that is, from a formatted date/time to YYYYMMDDHH24MISS format -- see http://www.autohotkey.com/forum/topic20405.html

[Titan]

Thanks!
_________________

RegExReplace("irc.freenode.net/autohotkey", "^(?=(.(?=[\0-r\[]*((?<=\.).))))(?:[c-\x73]{2,8}(\S))+((2)|\b[^\2-]){2}\D++$", "$u3$1$3$4$2")

[Ace_NoOne]

Impressive as usual, Titan!

However, I'm having trouble converting ISO 8601 timestamps:

[Titan]

Oh right, I forgot that T is an optional flag. Fixed in 1.01 thanks.

[philz]

[Ace_NoOne]

[engunneer]

totalTime_days is coming out D. first.

If I do this in a new script, I get the right number:

[Ace_NoOne]

This is a complete mystery to me - I've updated the test script above to display all relevant variables. However, that doesn't help me in figuring out what the problem is...

enguneer: The difference between your script and mine is that I have used DateParse() - corroborating my suspicion that it must have something to do with Titan's function!?
_________________
Improving my world, one script at a time.
Join the AutoHotkey IRC channel: irc.freenode.net #autohotkey

[Titan]

[Ace_NoOne]

[EdScriptNewbie]

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?), then add to or subtract from that date a certain number of days, and then, write the resulting new date into the field in a format it can use. The Outlook Task date field is in this format: "Wed 6/27/2007."
The following might make this easier:
1) the day name part of it is always three letters followed by a space, and
2) if you select the whole field and just paste in 6/28/2007, then when you tab onward, Outlook in its wisdom figures out how to make the field say "Thu 6/28/2007" all by itself.
_________________
...Ed

[Ace_NoOne]

EdScriptNewbie: Although you didn't really pose a question, I guess DateParse() will do what you need.

[Titan]

EdScriptNewbie, like Ace_NoOne demonstrated you can convert the string to an AutoHotkey compatible format using this function, add/subtract a number of days using EnvAdd/EnvSub, convert it back to the original date format using FormatTime and then send it back to Outlook with Send or ControlSend.

The script can be modified/distributed however you want as long as it includes the original version number, link to my site and a notice of GPL v2 - AutoHotkey comes with this licence so linking to a GNU site is not necessary, e.g.

[EdScriptNewbie]

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!
_________________
...Ed