topic Re: Seperate Date,Time & Country in QlikView https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389980#M820039 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,</STRONG></P><P><STRONG>Time#(<SPAN style="font-size: 13.3333px;">SubField(FieldName, ' ', 2), 'hh:mm') as Time,</SPAN></STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>SubField(FieldName, ' ', 3) as Country</STRONG></SPAN></P></BODY></HTML> Fri, 11 Aug 2017 14:01:05 GMT sunny_talwar 2017-08-11T14:01:05Z Seperate Date,Time & Country https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389979#M820038 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to Separate date, Time &amp; Country in load</P><P></P><P>My Data contains like below</P><P>13/Apr/2017 19:32 Europe/London</P><P>01/Jul/2017 Asia/Calcutta</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389979#M820038 DipeshVadgama 2020-11-25T16:16:04Z Re: Seperate Date,Time & Country https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389980#M820039 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,</STRONG></P><P><STRONG>Time#(<SPAN style="font-size: 13.3333px;">SubField(FieldName, ' ', 2), 'hh:mm') as Time,</SPAN></STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>SubField(FieldName, ' ', 3) as Country</STRONG></SPAN></P></BODY></HTML> Fri, 11 Aug 2017 14:01:05 GMT https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389980#M820039 sunny_talwar 2017-08-11T14:01:05Z Re: Seperate Date,Time & Country https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389981#M820040 <HTML><HEAD></HEAD><BODY><P>Sufield(yourfield,' ',1) as Date,</P><P><SPAN style="font-size: 13.3333px;">Sufield(yourfield,' ',-1) as Country,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If( <SPAN style="font-size: 13.3333px;">Sufield(yourfield,' ',-1)&nbsp; &lt;&gt; <SPAN style="font-size: 13.3333px;">Sufield(yourfield,' ',2),<SPAN style="font-size: 13.3333px;">Sufield(yourfield,' ',2)) as Time</SPAN></SPAN></SPAN><BR /></SPAN></P></BODY></HTML> Fri, 11 Aug 2017 14:02:04 GMT https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389981#M820040 Clever_Anjos 2017-08-11T14:02:04Z Re: Seperate Date,Time & Country https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389982#M820041 <HTML><HEAD></HEAD><BODY><P>Thanks Your both function works <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Aug 2017 14:12:02 GMT https://community.qlik.com/t5/QlikView/Seperate-Date-Time-Country/m-p/1389982#M820041 DipeshVadgama 2017-08-11T14:12:02Z