Get Yesterday's date in mm/dd/yyyy

[DigDeep]

I am able to get today's date in the MM/DD/YYYY format.

But I also want to get Yesterday's date in the same format. I tried using _DateADD but that gives me result in the M/DD/YYYY format.

Local $Today = _Date_Time_GetSystemTime()
Local $CalDate = _Date_Time_SystemTimeToDateStr($Today)

MsgBox(0, '', $CalDate)

Local $Yesterday = _DateTimeFormat(_DateAdd('d', -1, _NowCalcDate()), 2)

MsgBox(0, '', $Yesterday)

Can someone check once?

[Danp2]

.

Edited January 22, 2017 by Danp2
Nevermind

[DigDeep]

Yes, I tried that too as stated above.

Local $Yesterday = _DateAdd('d', -1, _NowCalcDate())

But that gives me in the YYYY/MM/DD format. I wanted to get the result in the MM/DD/YYYY format.

I also tried to take the _DateAdd to convert it to my result as per below, but the code does not run.

Local $Yesterday = _DateAdd('d', -1, _NowCalcDate())
Local $Yesterday1 = $Yesterday[1] & "/" & $Yesterday[2] & "/" & $Yesterday[0]

MsgBox(0, '', $Yesterday)

 

Edited January 22, 2017 by DigDeep

[Melba23]

DigDeep,

#include "Date.au3"

Local $Today = _Date_Time_GetSystemTime()
Local $CalDate = _Date_Time_SystemTimeToDateStr($Today)

MsgBox(0, '', $CalDate)

Local $Yesterday = _DateTimeFormat(_DateAdd('d', -1, _NowCalcDate()), 2)
; Split DTG
$aYesterday = StringSplit($Yesterday, "/")
; Reassemble in desired order
$sYesterdayFormatted = $aYesterday[2] & "/" & $aYesterday[1] & "/" & $aYesterday[3]
MsgBox(0, '', $Yesterday & @CRLF & $sYesterdayFormatted)

M23

[DigDeep]

Thanks @Melba23.

I just modified it a little bit and got it.

;~ Local $Yesterday = _DateTimeFormat(_DateAdd('d', -1, _NowCalcDate()), 2)
Local $Yesterday = _DateAdd('d', -1, _NowCalcDate())
; Split DTG
$aYesterday = StringSplit($Yesterday, "/")
; Reassemble in desired order
$sYesterdayFormatted = $aYesterday[2] & "/" & $aYesterday[3] & "/" & $aYesterday[1]
MsgBox(0, '', $Yesterday & @CRLF & $sYesterdayFormatted)

 

[Gianni]

... have also a look to the _DateTimeSplit() function

#include <date.au3>

Local $aDatePart ; will receive the date splitted in [1] year, [2] month, [3] day
Local $aTimePart ; not used here

Local $Yesterday = _DateAdd('d', -1, _NowCalcDate())

Local $x = _DateTimeSplit($Yesterday, $aDatePart, $aTimePart)

Local $Yesterday1 = $aDatePart[2] & "/" & $aDatePart[3] & "/" & $aDatePart[1]

MsgBox(0, '', $Yesterday1)