https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519891#M748406 <P>Hi Omar,</P><P>&nbsp;</P><P>Thanks for your reply, date() is not working here because in my date column having number format and text format so that's way date() and Date#() is not working. i need a solution like if a column have text format and number then it should convert into one unique date format.</P> Wed, 12 Dec 2018 14:27:54 GMT venkatbza 2018-12-12T14:27:54Z https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519883#M748403 <P>Hi Friends,</P><P>&nbsp;</P><P>how to get unique date format for below attached screen print?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="44035779.PNG" style="width: 193px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2052i4A7DF8C292E21608/image-size/large?v=v2&amp;px=999" role="button" title="44035779.PNG" alt="44035779.PNG" /></span></P> Sat, 16 Nov 2024 04:58:57 GMT https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519883#M748403 venkatbza 2024-11-16T04:58:57Z https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519886#M748404 <P>have you tried:</P><P>date(YourField)</P> Wed, 12 Dec 2018 14:20:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519886#M748404 OmarBenSalem 2018-12-12T14:20:23Z https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519889#M748405 <P>Or try this</P><PRE>Date(Alt(Num(DateField), Num(Date#(DateField, 'DD/MM/YYYY')))) as DateField</PRE> Wed, 12 Dec 2018 14:24:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519889#M748405 sunny_talwar 2018-12-12T14:24:39Z https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519891#M748406 <P>Hi Omar,</P><P>&nbsp;</P><P>Thanks for your reply, date() is not working here because in my date column having number format and text format so that's way date() and Date#() is not working. i need a solution like if a column have text format and number then it should convert into one unique date format.</P> Wed, 12 Dec 2018 14:27:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519891#M748406 venkatbza 2018-12-12T14:27:54Z https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519899#M748407 <P>Thanks Stalwar, its working.</P> Wed, 12 Dec 2018 14:37:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-unique-date-format/m-p/1519899#M748407 venkatbza 2018-12-12T14:37:00Z