change date format of date variable to something like 3/17/14

Hi all,

I have a variable which contains a date value (say date value is in A1). I want to paste this date value into a cell (say A2) but change the format from "mm/d/yyyy" to say "mm/d/yy". Here is the code i use.........but it doesnot work.

Please Login or Register  to view this content.

alert_due_date_value is the variable which contains the date........i try to convert its format to mm/d/yy and store result in variable junk1 but the displayed value in junk1 is the same as that for alert_due_date_value........any ideas what to do?

Is alert_due_date_value a date?
You could try

Please Login or Register  to view this content.

no actually i think its a variant......because i dont declare it.......i know bad practice

would being a variant cause the problem

Did you try?

Please Login or Register  to view this content.

ok tried what you suggested and that did not work.........still showing year with 4 digits and not 2

I suggest you should the variable to date. If this does not make any difference, we need to see what kind of data you are working on.

ok will try that and let you know......back in a hour

ok back........what i found works is the following......well it worked in a test file anyway......

Please Login or Register  to view this content.

i then use the yr_txt and day_txt and Mnth_2Digit variables concatented in a string and i get what i want.....

ok....it worked and didnt work........when i paste into sheet it converts it from 10/14/14 to 10/14/2014..........not sure why

Have you tried Excel's formatting functions? If it worked, but not now, it may be to do with formatting in new sheet.
What types of variables are you declaring?

the variables i have tried as a date and variant.........i have a text string of "10/14/14" but when i place it into a cell it becomes 10/14/2014.

the variables i have tried as a date and variant.........i have a text string of "10/14/14" but when i place it into a cell it becomes 10/14/2014.

ok....this seems to work.........

Please Login or Register  to view this content.

not sure why....i think its because i formatted the cell first.........

Yes, that was my thought. The cells you are pasting might been formatted as "Text"