Year Format not changing

[gchichester]

I have set the date format on the PC to Short Date 11/25/16 when I run this code
the Watch shows;
0: BATCHDATE=DRG11252016
0: CYEAR=2016
0: CDAY=25
0: CMONTH=11
0: TODAY=11/25/16
0: BATCHPRE=DRG

[code]GetDate>today
DatePart>today,M,CMonth
DatePart>today,D,CDay
DatePart>today,Y,CYear
Let>BatchDate=%BatchPre%%CMonth%%CDay%%CYear%
msg>BatchDate[/code]

The resulting variable displays the as 2016
What's wrong with my code?

[Marcus Tettmar]

That's what DatePart does. Returns the full year from a date.

If you just want to remove portions of the short date as is then use MidStr:

Code: Select all

MidStr>today,7,2,yearDigits

Or my preference for total portability would be:

Code: Select all

Year>yyyy
MidStr>yyyy,3,2,yy

[gchichester]

Thanks for your response!
When I reviewed the Watch List and saw 0: TODAY=11/25/16, I was expecting the year format to be 16
So If I understand correctly DatePart is not looking at the system Date format for it's results?

[Marcus Tettmar]

It wants a valid date format. What a valid date is is somewhat dictated by the system settings. So it DOES look at it, but it is not a substring tool. It still returns a year value. Year values are 4 digits.

[gchichester]

Thanks for the explanation.