I need to change a date and time field into (or convert in an adjacent column) a long integer but transpose the date part.

For example I want 12/04/2008 19:22:59 to read 20080412192259



Anyone got any ideas that will help?

Thanks in advance............