topic Re: Date format in QlikView https://community.qlik.com/t5/QlikView/Date-format/m-p/71455#M775185 <HTML><HEAD></HEAD><BODY><P>Hi Ansh,</P><P></P><P>Lets say we have a date field EgDate.</P><P></P><P>Date( Floor( Timestamp#( <SPAN style="font-size: 13.3333px;">EgDate</SPAN>, 'YYYY-MM-DD hh:mm:ss')), 'M/D/YYYY') as ModifiedDate.</P><P></P><P>Regards,</P><P>Akshaya</P></BODY></HTML> Tue, 08 May 2018 19:17:57 GMT adityaakshaya 2018-05-08T19:17:57Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/71454#M775184 <HTML><HEAD></HEAD><BODY><P>I have attached date format...How to convert that to regular date ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/71454#M775184 apthansh 2020-11-25T16:16:04Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/71455#M775185 <HTML><HEAD></HEAD><BODY><P>Hi Ansh,</P><P></P><P>Lets say we have a date field EgDate.</P><P></P><P>Date( Floor( Timestamp#( <SPAN style="font-size: 13.3333px;">EgDate</SPAN>, 'YYYY-MM-DD hh:mm:ss')), 'M/D/YYYY') as ModifiedDate.</P><P></P><P>Regards,</P><P>Akshaya</P></BODY></HTML> Tue, 08 May 2018 19:17:57 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/71455#M775185 adityaakshaya 2018-05-08T19:17:57Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/71456#M775186 <HTML><HEAD></HEAD><BODY><P>There are two formats in your screenshot.</P><P>Which one is your source format?</P></BODY></HTML> Tue, 08 May 2018 21:10:33 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/71456#M775186 MarcoWedel 2018-05-08T21:10:33Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/71457#M775187 <HTML><HEAD></HEAD><BODY><P>Besides your source format, one solution to convert a timestamp into a date is the <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/dayname.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/dayname.htm">Dayname()</A><SPAN style="font-size: 10pt;"> function.</SPAN></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 08 May 2018 21:13:32 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/71457#M775187 MarcoWedel 2018-05-08T21:13:32Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/71458#M775188 <HTML><HEAD></HEAD><BODY><P>Use Date(Floor(Date),'YYYY-MM-DD')</P></BODY></HTML> Wed, 09 May 2018 12:29:04 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/71458#M775188 sasiparupudi1 2018-05-09T12:29:04Z