how to convert datetime to number

[#1]

Hi Everyone,

I have the following datetime format:

12/11/2010 15:30:00 

I would like to know how I can convert this date to look as follow:

20101112153000

Thanks

[MK_QSL]

TimeStamp(TimeStamp#('12/11/2010 15:30:00','DD/MM/YYYY hh:mm:ss'),'YYYYMMDDhhmmss')

If it is DD/MM then change accordingly..

[sasiparupudi1]

if your datatime is not a string,you could use

TimeStamp(YourDateTime,'YYYYMMDDhhmmss')

if it is a string value, then you need to convert it using timestamp#

TimeStamp(TimeStamp#('12/11/2010 15:30:00','DD/MM/YYYY hh:mm:ss'),'YYYYMMDDhhmmss')

hth

Sasi