Or you can do this in a query by parsing the date and then reconstructing it:

In this example my UglyDate looks like this:
Wed Mar 17, 2010  10:07 PM

SELECT [Tbl_UglyDate].[UglyDate], Mid([UglyDate],5,3) AS M, Mid([UglyDate],9,2) AS D,
Mid([UglyDate],13,4) AS Y, Month("1 " &amp; [M]) AS M2, 
([M2] &amp; "/" &amp; [D] &amp; "/" &amp; [Y]) AS date1, CVDate([date1]) AS [date] 
FROM [Tbl_UglyDate];


How do I convert date in VBA with format "YYYYMMDD HHMMSS"?
I'm trying to build a script that uses both a browser and a texteditor. The workflow I can summarize as follows:


Right click on a video for streaming
Click on the option to copy the redirection link
Switch to a text editor (Slickedit in my case)
Paste the copied link
Go back to the browser and await next command.


I want to automate this with a single key press while I am standing on the link with the mouse. This has been
my attempt:

^+!a::
    Click Right, 392, 64     ;execute in browser
    Click Left, 410, 79      ;
    Send, !{Tab}             ;switch to text editor
    Send, ^V                 ;paste in text editor
    Send, !{Tab}             ;switch back to browser
return


The script isn't working correctly because it appears not to be executing the ^V command.
I suspect it's because it is executing it before Slickedit is even active.  How can I syncronize
these KeyPreses so that they are executed at the right times? Also is there a nicer way for me to
switch to Slickedit without relying on the alt-tab?
