Code to turn 4 digit year to 2 digit

**phbryan** · 10-30-2015, 11:32 AM

i have a code that grabs a date from a stores it in a variable
i then what to grab the year from that date and store it in another variable but only the last two digits (2015 would become 15)

Please Login or Register  to view this content.

is there a change to this line to make that happen?

Thank you

**skywriter** · 10-30-2015, 11:38 AM

Try this.

Please Login or Register  to view this content.

**phbryan** · 10-30-2015, 12:56 PM

That did it,
thank you!

**skywriter** · 10-30-2015, 01:55 PM

My pleasure, thanks for the rep. points.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Code to turn 4 digit year to 2 digit

LinkBack

Thread Tools

Rate This Thread

Display

Code to turn 4 digit year to 2 digit

Re: Code to turn 4 digit year to 2 digit

Re: Code to turn 4 digit year to 2 digit

Re: Code to turn 4 digit year to 2 digit

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dates turn into 5-digit number

Macro to identify 3-digit and 4-digit numbers as valid dates

Create a 3 digit alphanumeric series in a sequential order but the first digit must be 1

[SOLVED] convert a 4 digit zip code to 5 digit zip code

[SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash

How to format a date into a 2-digit code which indicates the year?

Entering 5 digit number, where each digit creates a specific result based on a list.

Bookmarks

Bookmarks

Posting Permissions