topic Re: Help in Date. in QlikView https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72104#M771065 <HTML><HEAD></HEAD><BODY><P>Without Left or Right? May be using SubField?</P><P></P><P><STRONG>Date(Date#(SubField(DateField, 'T', 1), 'YYYY-MM-DD') as Date</STRONG></P></BODY></HTML> Thu, 07 Jun 2018 15:24:06 GMT sunny_talwar 2018-06-07T15:24:06Z Help in Date. https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72102#M771062 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have date like in below.How to exctact date from that can you help me out. with out using left and right functions.</P><P></P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="326" style="width: 166px; height: 326px;" width="166"><TBODY><TR><TD height="20" width="132">Start Time (GMT+0)</TD></TR><TR><TD height="20">2018-05-30T00:00:00</TD></TR><TR><TD height="20">2018-05-31T00:00:00</TD></TR><TR><TD height="20">2018-06-01T00:00:00</TD></TR><TR><TD height="20">2018-06-02T00:00:00</TD></TR><TR><TD height="20">2018-06-03T00:00:00</TD></TR><TR><TD height="20">2018-06-04T00:00:00</TD></TR><TR><TD height="20">2018-06-05T00:00:00</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72102#M771062 vinod22kv 2020-11-25T16:16:04Z Re: Help in Date. https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72103#M771063 <HTML><HEAD></HEAD><BODY><P>What is the expected output you are looking for may be use below</P><P>Replace the date with your FieldName </P><P></P><P>= ConvertToLocalTime('2018-05-30T00:00:00', 'GMT')</P></BODY></HTML> Thu, 07 Jun 2018 15:23:39 GMT https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72103#M771063 vishsaggi 2018-06-07T15:23:39Z Re: Help in Date. https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72104#M771065 <HTML><HEAD></HEAD><BODY><P>Without Left or Right? May be using SubField?</P><P></P><P><STRONG>Date(Date#(SubField(DateField, 'T', 1), 'YYYY-MM-DD') as Date</STRONG></P></BODY></HTML> Thu, 07 Jun 2018 15:24:06 GMT https://community.qlik.com/t5/QlikView/Help-in-Date/m-p/72104#M771065 sunny_talwar 2018-06-07T15:24:06Z