Date format yymmdd

[EricF]

Hello,

I would like to use the yymmdd date format, but it seems that it's not possible to specify a specific date format. How to do this (uses 2 digits for the year) ? The short date format on my PC is dd/mm/yyyy and I don't want to change it.

[everseeker]

Hello,

I would like to use the yymmdd date format, but it seems that it's not possible to specify a specific date format. How to do this (uses 2 digits for the year) ? The short date format on my PC is dd/mm/yyyy and I don't want to change it.

_Date_Time_SystemTimeToArray

then display the array any way you like...

or

_DayValueToDate

as shown in the help file...

Dim $Y, $M, $D

$sJulDate = _DayValueToDate ($sJulDate-14, $Y, $M, $D)

MsgBox(4096, "", "14 days ago:" & $M & "/" & $D & "/" & $Y & " (" & $sJulDate & ")")

you can trim $Y to 2 digits.......

Edited March 27, 2008 by everseeker

[Jos]

I would take the simple approach:

StringMid(@YEAR & @MON & @MDAY, 3)

[everseeker]

I would take the simple approach:

StringMid(@YEAR & @MON & @MDAY, 3)

that too..

[EricF]

Thanks