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............