I have an input macro that reuest a user to enter a date..
I am using the input to run update queries for multiple sources..
my question is how can I change the format for the different sources in the macro versus having the user enter the input different time different ways
I currently have the user entering a date a mmddyy (010105)
this opens datatables in multple databases named the same as the input(ie 010105)
now I need to change the format of that so that it reflects as 01/01/05 to auto update a pivot table.. I currently have everthing i need.. i just need to convert the 010105 to 01/01/05.
I tried to use format(x, "mm/dd/yy"), but since I am not collecting the user input as a date originally it gives some real funky results (010105 = 8/31/1927)..
I imagine something like len, right, left might do the trick.. but as far as how to write that out.. I'm lost
Thanks in advance
I am using the input to run update queries for multiple sources..
my question is how can I change the format for the different sources in the macro versus having the user enter the input different time different ways
I currently have the user entering a date a mmddyy (010105)
this opens datatables in multple databases named the same as the input(ie 010105)
now I need to change the format of that so that it reflects as 01/01/05 to auto update a pivot table.. I currently have everthing i need.. i just need to convert the 010105 to 01/01/05.
I tried to use format(x, "mm/dd/yy"), but since I am not collecting the user input as a date originally it gives some real funky results (010105 = 8/31/1927)..
I imagine something like len, right, left might do the trick.. but as far as how to write that out.. I'm lost
Thanks in advance