How to change the date time format to date for the given format?

[#1]

Hi

I have a  date in format as '2015-03-02T00:47:34'  i want this to be changed to date format only. Please help.

[arulsettu · Accepted solution]

try like this

DATE(Left('2015-03-02T00:47:34',10),'YYYY/MM/DD')

[Kushal_Chawda]

date(DATE#(Left(trim(Date),10),'YYYY-MM-DD'),'DD-MMM-YYYY')

[HirisH_V7]

Hi,

😧

LOAD * INLINE [

    Date

    "2015-03-02T00:47:34"

];

D2:

LOAD

SubField(Date,'T',1) As SDate

Resident D;

DROP table D;

D3:

load

Date(SDate,'DD-MM-YYYY') as  Finaldate

Resident D2;

Drop table D2;

Please check the attachment.

!

Hope this helps,

Regards,

Hirish

[MarcoWedel]

another one:

Date(Date#(Subfield('2015-03-02T00:47:34','T',1),'YYYY-MM-DD'))

to convert to your default DateFormat.

hope this helps

regards

Marco

[jagan]

Hi,

Try like this

=Date(Date#(Left(Date, 10),'YYYY-MM-DD'))

Hope this helps you.

Regards,

Jagan.

[#7]

Thank you guys all the given answers are working:)

[#8]

Hi,

DATE(Left('date',10),'YYYY/MM/DD')