JZB
07-03-2009, 06:25 AM
Hi Guys
I am trying to compare two sets of data, but one has dates in US format and the other in International
07/02/2009 = 39851
02/07/2009 = 39996
I am trying to change the US format around.
I thought the best way would be to define the variables
month = left("a1",2)
day = mid("a1",4,6)
year = right("a1",4)
A1 being the date 07/02/2009 (not 39851)
but this does not seem to produce the desired 07, 02, 2009. instead it brings back 39, 51, 9851. i dont know why.:banghead:
therefore making it impossible to move onto the next step of pulling the variables together into the correct format.
Any ideas? stuck on this one.
Thanks
Jon
I am trying to compare two sets of data, but one has dates in US format and the other in International
07/02/2009 = 39851
02/07/2009 = 39996
I am trying to change the US format around.
I thought the best way would be to define the variables
month = left("a1",2)
day = mid("a1",4,6)
year = right("a1",4)
A1 being the date 07/02/2009 (not 39851)
but this does not seem to produce the desired 07, 02, 2009. instead it brings back 39, 51, 9851. i dont know why.:banghead:
therefore making it impossible to move onto the next step of pulling the variables together into the correct format.
Any ideas? stuck on this one.
Thanks
Jon