12-13-2014, 10:50 AM
Hi Friends,
I am having trouble with comparing strings.
I have a date picked from excel and I need just the date part.
I would need 2 digits if date is greater than 9 and only 1 digit if less than 10.
Reason: If less than 10 then the date picked from excel would have 0 preceeding the actual date and would create havoc while selecting date on a website.
Below is the code I have been trying to work on:
Macro RO Sales VISTA
I am having trouble with comparing strings.
I have a date picked from excel and I need just the date part.
I would need 2 digits if date is greater than 9 and only 1 digit if less than 10.
Reason: If less than 10 then the date picked from excel would have 0 preceeding the actual date and would create havoc while selecting date on a website.
Below is the code I have been trying to work on:
Macro RO Sales VISTA
Best Regards,
Philip
Philip