topic Re: How to reformat date in QlikView https://community.qlik.com/t5/QlikView/How-to-reformat-date/m-p/1302788#M405812 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Date(MonthStart(Floor(TimeStamp#(SubField([First Discovered], ' E', 1), 'MMM DD, YYYY hh:mm:ss'))), 'MMM YYYY') as MonthYear,</STRONG></SPAN></P></BODY></HTML> Wed, 29 Mar 2017 15:04:24 GMT sunny_talwar 2017-03-29T15:04:24Z How to reformat date https://community.qlik.com/t5/QlikView/How-to-reformat-date/m-p/1302787#M405811 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a date field already defined converting from Jan 1, 2000 10:38:50 AM EST to 1/1/2000</P><P>But I am looking to create a MonthYear to then take that number and change it to Jan 2000, while still keeping the 1/1/2000 field as well. How would I do that? Here's what I have so far.</P><P></P><P></P><P>[First Discovered], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Floor(TimeStamp#(SubField([First Discovered], ' E', 1), 'MMM DD, YYYY hh:mm:ss'))) as First_Discovered,</P><P></P><P>Thanks</P></BODY></HTML> Wed, 29 Mar 2017 15:00:46 GMT https://community.qlik.com/t5/QlikView/How-to-reformat-date/m-p/1302787#M405811 2017-03-29T15:00:46Z Re: How to reformat date https://community.qlik.com/t5/QlikView/How-to-reformat-date/m-p/1302788#M405812 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Date(MonthStart(Floor(TimeStamp#(SubField([First Discovered], ' E', 1), 'MMM DD, YYYY hh:mm:ss'))), 'MMM YYYY') as MonthYear,</STRONG></SPAN></P></BODY></HTML> Wed, 29 Mar 2017 15:04:24 GMT https://community.qlik.com/t5/QlikView/How-to-reformat-date/m-p/1302788#M405812 sunny_talwar 2017-03-29T15:04:24Z