Convert Datetime Stamp to Decimal (1,2,3 places)

[#1]

Hi  All,

     How to convert Datetime Stamp to Decimal values(1,2,3 places).

Thanks & regards,

Madhu

reddys310‌

jimhalpert‌

[Chanty4u]

can you eloberate your issue?

[Chanty4u]

like ethis?

date#(subfield(MyDateString,' ',1),'dd.MM.yyyy') as MyDate

date#(subfield(MyDateString,' ',2),'hh:mm:ss') as MyTime

[migueldelval]

Hi Sai,

I can´t uderstand you so well.

num(DATE_FIELD, '###,000') ???

Regards

Miguel del Valle

[Anil_Babu_Samineni]

Hope this helps

Logic behind date conversion