Date Minus one issue...

[Hyflex]

Hey AutoIt,

I have a problem with a date variable.

$ReportDate = @MDAY - 1 & "/" & @MON & "/" & StringRight(@YEAR, 2)

Today's Date minus 1 (to make it yesterdays date) brings up an issue at the end of the month where it doesnt change month correctly and doesn't go back correct.

Please help

- Hyflex

[BrewManNH]

Use _DateAdd with a negative number to subtract from the date you input, doing it the way you're doing it will only subtract from the day and the month isn't affected.

[saywell]

Try

_DateToDayValue to get numerical value for the day

subtract 1 to get num value for the day before

then

_DayValueToDate to get gregorian date for that day.

Or perhaps _DateAdd with a negative difference.

William

[Hyflex]

I've been looking at _DateAdd using

_DateAdd('d', 1, _NowCalcDate())

but have an issue with the fact the date is in an American format.

I can't work out how to create a pattern using StringRegExpReplace

I really don't want to use the folllowing:

$RawDate = _DateAdd('d', -1, _NowCalcDate())
$DateSmallYear = StringRight(StringLeft($RawDate, 4), 2)
$DateDay = StringRight(StringRight($RawtDate, 5), 2)
$DateMonth = StringLeft(StringRight($RawDate, 5), 2)
$FullDate = $DateDay & "/" & $DateMonth & "/" & $DateSmallYear

Edited July 17, 2012 by Hyflex

[czardas]

I wrote some but I think it's too much for what you want. I would do something like this:

#include <Date.au3>

$sDate = _DateAdd('d', -1, _NowCalcDate())
$aArray = StringSplit($sDate, "/", 2)
$sDate = $aArray[2] &"/"& $aArray[1] &"/"& StringRight($aArray[0], 2)
MsgBox(0, "", $sDate)

[BrewManNH]

If your date format is in mm/dd/yyyy instead of yyyy/mm/dd use the following code to convert it. There are separate formulae depending upon the format of single digit month and day.

$Date = "07/17/2012" ; date in mm/dd/yyyy format
$ConvertedDate = StringRight($Date, 4) & "/" & StringLeft($Date, 2) & "/" & StringMid($Date, 4, 2) ; date in yyyy/mm/dd format
ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $ConvertedDate = ' & $ConvertedDate & @crlf & '>Error code: ' & @error & @crlf) ;### Debug Console
; if month or day is single digit and doesn't have leading 0 consistently use the following formula
$Date = "7/7/2012" ; date in mm/dd/yyyy format no leading zeros
$ConvertedDate = StringRight($Date, 4) & "/" & StringFormat("%02s", StringReplace(StringLeft($Date, 2), "/", "")) & "/" & StringFormat("%02s", StringReplace(StringMid($Date, 3, 2), "/", "")) ; date in yyyy/mm/dd format
ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $ConvertedDate = ' & $ConvertedDate & @crlf & '>Error code: ' & @error & @crlf) ;### Debug Console

[Hyflex]

czardas,

Thank you very much for your help that helps me a lot.

BrewManNH,

Wow, thanks for that it again that helped me quite a lot, I'm British we put our dates in the format of: DD/MM/YYYY or (DD/MM/YY)thank you ever so much though.

Cheers guys, you've helped fix something what has been bugging me for months and months.

[czardas]

Glad to help. I know exactly what you mean about date confusion with short year format. Good luck with your project.