Date

[smilingjohn]

HI all

Currently my Date format for the field " Datefield" is like this

24-MAY-17 01.30.58.000000000 PM

i want to convert this this Datefield like   24-05-2017

How do i achaive this ?

Can someone please help me

Thanks in advance

[its_anandrjs]

Close the thread buddy by appropriate answers and for references.

[its_anandrjs]

Ok thanks then try this

Timestamp(Timestamp#(left(DateString,18),'DD-MMM-YY hh.mm.ss'),'DD-MM-YYYY hh:mm:ss') as NewDate