Jump to content
ur

How to get previous date from a string

Recommended Posts

ur

I have date in the string format as "DD-MM-YYYY".

 

I need to get yesterday's date from it.

I tried converting this from _DateTimeFormat but not working.

Is there any direct UDF available to get this.?

Share this post


Link to post
Share on other sites
ur

Oh!! Thanks @jguinch

Unnecessarily, I created below logic in the meanwhile.

Func yeterdayDate($sDate)

$f =  StringSplit($sDate,"-");StringSplit("22-01-2018","-")
_ArrayDisplay($f)
if $f[1]>1 then
    $f[1]-= 1
Else
    If Number($f[2])-1 =1 or Number($f[2])=3 or Number($f[2])=5 or Number($f[2])=7 or Number($f[2])=8 or Number($f[2])=10 or Number($f[2])=12 Then
        $f[1]=31
    ElseIf Number($f[2] - 1) < 1 Then
        $f[1]=31
        $f[2]=12
        $f[3]=Number($f[3])-1
    Else
        $f[1]=30
    EndIf
EndIf

padZero($f[1])
padZero($f[2])
padZero($f[3])

;MsgBox(0,"",$f[1]&"-"&$f[2]&"-"&$f[3])
return $f[1]&"-"&$f[2]&"-"&$f[3]

EndFunc

Func padZero(ByRef $sValue)
    if Number($sValue)<10 Then
        $sValue = "0"&Number($sValue)
    EndIf
EndFunc

 

Share this post


Link to post
Share on other sites
jguinch
#Include <Date.au3>

Local $sDate = "01-01-2018"
Local $sDatePreviousDay = _DateAdd("D", -1,  StringRegExpReplace($sDate, "(\d{2})[/-](\d{2})[/-](\d{4})", "$3/$2/$1") )
ConsoleWrite($sDatePreviousDay)

;)

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

    • Miliardsto
      By Miliardsto
      I got that func
      Func makeHelpImgGUI($title,$width,$height,$img) $img = GUICtrlCreatePic("",20,40,$width,$height) _ResourceSetImageToCtrl($img, "HERE") EndFunc and I call this func like that
      makeHelpImgGUI("Image",1190, 800,$SETTINGS_JPG)  
      so what is the problem in the parameter where is - "HERE" I need value of img but passed as string
      so $img = $SETTINGS_JPG and how make it "SETTINGS_JPG"
       
      I tried something like that but not work
      Func makeHelpImgGUI($title,$width,$height,$img) $name_str = String($img) $name_str = StringTrimLeft ($name_str, 1 ) $img = GUICtrlCreatePic("",20,40,$width,$height) _ResourceSetImageToCtrl($img, $name_str) EndFunc  
    • Jemboy
      By Jemboy
      Hi,
      Ones(some times twice) a month I get an e-mail with zip file, which has price updates from a supplier.
      I have to upload the file to an FTP to get it processed.
      When uploading the file, it will get "timestamped" with the time and date at which time the file was uploaded.
      Normally this is fine, because I mostly upload the file the same day.
      Sometimes it may take 1 or 2 days before I can upload the file.
      For historical purpose, I would like to have the file timestamped with the original date.
      I have tried using:  _FTP_Command ( $hFTPSession, "MFCT YYYYMMDDHHMMSS path") 
      however this command does not work or change the timestamp as I expected.
      Does anyone now a way how I can change the timestamp of a FTP-file?
    • liagason
      By liagason
      Hello everyone,
      How can I display in ascending  sequence some numbers stored in a string variable?
      $str = "18,03,48,23" MsgBox(0,"test",$str) I would like it to display "03,18,23,48"
    • Rskm
      By Rskm
      Hi, I have the following line in a text file 'input.txt'. I know the line number - say '6'. I wish to replace the text 'WWW' in the below line with a random number (I can generate that with random()).
      WERIS  WWWJP   3.83  8.330  1.000                1097.RAXX 
      The WWW is a 3 digit integer (could be any number between 0 to 999), I can use stringtrimleft and get the numerical value of WWW in this file
      so, basically, I know the string to replace (ie; WWW stored in a variable), I know the line number to work on and the file location/name and the replacement variable (through random()). My requirement is to fill that 3 spaces with my random number (which Is a integer between 1 and 999)
      please put ur suggestions
       
    • nacerbaaziz
      By nacerbaaziz
      Hello Members of this best Forum
      i have a question please
      for example if i have a long string
      and i want to extract a text between two tag
      what i can do to make that?
      note :
      i know that there is a
      StringRegExp function
      it's do that work
      but it result is be as an array
      i want the result to be a string
      is there any function on autoit can do that?
      Thanks in advance.
×