Reverse Text for Lot Code based off of today's date 追蹤

0
Avatar
Andrew Lehtinen

I have a label I am working on, I want to take today's date (01/31/20) and reverse that automatically into the lot code format which is the date in reverse (021310). Is there a way to do this? I'm not sure if this is a script to implement on this data. 

1 意見

0
Avatar
Pete Thane
評論操作 永久連結

Maybe no need to VB as you can do this from the Date Type option and choose Custom giving and the format 

yyMMdd

(Note the MM must be in capitals)

登入寫評論。