litlmike

Date Format Re-arranging

9 posts in this topic




Where is the date coming from?


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

Is this formar always the same? 

Oct. 19, 2015

-> MM. DD, YYYY 


Please don't send me any personal message and ask for support! I will not reply!

Selection of finest graphical examples at Codepen.io

The own fart smells best!
Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!
¯\_(ツ)_/¯  ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ

Share this post


Link to post
Share on other sites

Where is the date coming from?

Long story, but it is coming from a ClipGet().  

 

Is this formar always the same? 

-> MM. DD, YYYY 

It is always the same, except that some months like May, June, and July may not have a period (".") following it.

Share this post


Link to post
Share on other sites

The clipboard must be getting the text from somewhere, what program is it coming from and can that program be made to output the date in a different format?


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

The clipboard must be getting the text from somewhere, what program is it coming from and can that program be made to output the date in a different format?

It's coming from highlighted text in Chrome.  Psuedo:

 

MouseClick("Left", 500,500, 3)
Send("^c")
$sDate = ClipGet()

I have tried MANY ways to get this data otherwise.  So now, I am just trying to convert the dates.  Thanks.

Share this post


Link to post
Share on other sites

Try this:

#include <Array.au3>

$sClipboard = "Oct. 19, 2015"

ConsoleWrite(Convert($sClipboard)& @CRLF)

Func Convert($sDate) ;output MM/DD/YYYY
    Local $aMonth[13] = ["", "Jan.", "Feb.", "Mar.", "Apr.", "May", "June", "July", "Aug.", "Sep.", "Oct.", "Nov.", "Dec."]
    Return StringFormat("%02i/%02i/%4i", _
                                _ArraySearch($aMonth, StringRegExpReplace($sDate, "(.+?)\h*\d+,\h*\d+", "$1")), _
                                StringRegExpReplace($sDate, ".+\h+(\d+?),\h+\d+", "$1"), _
                                StringRegExpReplace($sDate, ".+,\h*(\d+?)", "$1"))
EndFunc

 


Please don't send me any personal message and ask for support! I will not reply!

Selection of finest graphical examples at Codepen.io

The own fart smells best!
Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!
¯\_(ツ)_/¯  ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ

Share this post


Link to post
Share on other sites

Try this:

#include <Array.au3>

$sClipboard = "Oct. 19, 2015"

ConsoleWrite(Convert($sClipboard)& @CRLF)

Func Convert($sDate) ;output MM/DD/YYYY
    Local $aMonth[13] = ["", "Jan.", "Feb.", "Mar.", "Apr.", "May", "June", "July", "Aug.", "Sep.", "Oct.", "Nov.", "Dec."]
    Return StringFormat("%02i/%02i/%4i", _
                                _ArraySearch($aMonth, StringRegExpReplace($sDate, "(.+?)\h*\d+,\h*\d+", "$1")), _
                                StringRegExpReplace($sDate, ".+\h+(\d+?),\h+\d+", "$1"), _
                                StringRegExpReplace($sDate, ".+,\h*(\d+?)", "$1"))
EndFunc

 

Thanks!

Share this post


Link to post
Share on other sites

You can also look at the Date_Time_Convert UDF by Melba23.  This is really good when you need to convert between a lot of different formats.  

#include <DTC.au3>

$sDate = "Oct. 19, 2015"

ConsoleWrite(_Date_Time_Convert($sDate, "MMM. dd, yyyy", "MM/dd/yyyy") & @CRLF)

 

Adam

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • Ganesh2VL
      By Ganesh2VL
      Dears,
      The below code is working(20170314) in my UAT system but the same not working (-1-1-1) on production system.
      Please note  "_NowCalc()" returning correct date time on all machine/systems.
      What could be the issue? Please help.
      Func GetDateYYYYMMDD()
         Local $aMyDate, $aMyTime
      _DateTimeSplit(_DateTimeFormat(_NowCalc(), 1), $aMyDate, $aMyTime)
      Local $iLenDay = StringLen($aMyDate[1])
      Local $iLenMon = StringLen($aMyDate[2])
      if $iLenDay = 1 Then
         $aMyDate[1] = "0"&$aMyDate[1]
      EndIf
      if $iLenMon = 1 Then
         $aMyDate[2] = "0"&$aMyDate[2]
      EndIf
         Local $newDateFormat = $aMyDate[3] & $aMyDate[2] & $aMyDate[1]
      MsgBox($MB_SYSTEMMODAL, "", "New Date " &  $newDateFormat )
      Return $newDateFormat
      EndFunc
    • GreenCan
      By GreenCan
      I am currently working on a project in which I have to find timestamps in multiple formated patterns.
      The idea is to search time stamps in log files.
      If successful _GetDateInString() will returns a timestamp in YYYY/MM/DD hh:mm:ss
      Example:
      _GetDateInString("...Process Last Run 17 JUN at 05:15...", "DD Mon at hh:mm")
      will return 2014/06/17 05:15:00
      Formats tested:
      - DDMonYY hh:mm:ss  (matches dates like 30May14 03:59:59)
      - DD Mon YYYY hh:mm   - Mon, DD YYYY hh:mm:ss   - Mon, D YYYY hh:mm:ss   - DD Mon at hh:mm
      - DMonYY hh:mm:ss     - DMon hh:mm:ss           - DD/MM/YYYY hh:mm       - DD-MM-YYYY  hh:mm
      - DDMMYYYY hh:mm      - DD/MM hh:mm             - MM.DD.YYYY  hh:mm      - YYYYDDMM  hh:mm
      - YYYYMMDD - hh:mm    - DD.MM  hh:mm            - D/M/YYYY hh:mm         - D.M.YYYY hh:mm
      - M.D.YY h:mm:ss      - M.D.YY hh:mm            - M.D.YY  hh:mm          - M.D.YYYY h:mm:ss
      - M.D.YYYY  h:mm:ss   - M.D at  h:mm:ss        
      and many other formats...
      udf with examples:
      _GetDateInString 1.0.0.1.au3
       
      GreenCan