Help in Date.

[vinod22kv]

Hi,

I have date like in below.How to exctact date from that can you help me out. with out using left and right functions.

Start Time (GMT+0)

2018-05-30T00:00:00

2018-05-31T00:00:00

2018-06-01T00:00:00

2018-06-02T00:00:00

2018-06-03T00:00:00

2018-06-04T00:00:00

2018-06-05T00:00:00

[vishsaggi]

What is the expected output you are looking for may be use below

Replace the date with your FieldName

= ConvertToLocalTime('2018-05-30T00:00:00', 'GMT')

[sunny_talwar]

Without Left or Right? May be using SubField?

Date(Date#(SubField(DateField, 'T', 1), 'YYYY-MM-DD') as Date