Jump to content
Sign in to follow this  
EricF

Date format yymmdd

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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 by everseeker

Everseeker

Share this post


Link to post
Share on other sites
everseeker

I would take the simple approach:

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

:)

that too..

Everseeker

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
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.