Converting Date Format

[DigDeep]

Hi,

I am converting -NowDate() format from 'M/DD/YYYY' to 'MM/DD/YYYY' and it looks weird that out of 10 machines 2 machines give the below error.

Is there any other way I can try this out to get the date format in MM/DD/YYYY?

Local $Today = _NowDate() ; Get Today's Date
    Local $Date = StringSplit($Today, "/")
    Local $GetAppDate = StringRight($Today, 2) < StringLeft(@YEAR, 2) ? StringFormat("%02d/%02d/%d", $Date[1], $Date[2], $Date[3]) : StringFormat("%02d/%02d/%d", $Date[1], $Date[2], $Date[3]) ; Convert _NowDate() M/DD/YYYY to MM/DD/YYYY

Error: Array variable has incorrect number of subscripts or subscript dimension range

[FrancescoDiMuro]

@DigDeep
On those two machines, put an _ArrayDisplay(), which displays the $Date array.
That error means that $Date has less values than you are "requesting".
Do that try, and let us know

[jchd]

Maybe the failing machines use another locale, hence some separator but not a slash.

[caramen]

Guessing about check the local time settings.

When you got 4 results in one variable. If you're trying to access to a non existing result in that variable you gonna have this error.

 

You can use

UBound

to count the number of result in a variable.

 

 

[xcaliber13]

I use this to format dates

Local $hDate = StringFormat("%02u/%02u/", @MON, @MDAY) & StringRight(@Year, 4) ; Format = MM/DD/YYYY

This will get you current date in the format you are looking for.

[rudi]

Hi,

@Melba23 has a UDF that might help you (just noticed it in some of Melba's postings, never tried it)

 

 

Regards, Rudi.