Change date format

[#1]

Dear all,

How can I change below dateformat into a usable one:

Sep 30 2013 12:58AM

I already have the time covered, but I cannot seem to get the date converted.

[#2]

It turns blank.

Please see attached for the example.

[Jason_Michaelides]

You have extra spaces in the format.  This works:

Date(TimeStamp#(Replace(Time,'  ',' '),'MMM D YYYY hh:mmtt'),'DD-MM-YYYY hh:mm:ss')

The replace() swaps all double-spaces with a single.

[#4]

Now it works. Thanks!