topic Re: Nested Date functions in QlikView https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205260#M387486 <HTML><HEAD></HEAD><BODY><P>what date# does here ? Examples in the help are not clear. Please clarify.</P></BODY></HTML> Thu, 06 Oct 2016 12:22:55 GMT 2016-10-06T12:22:55Z Nested Date functions https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205258#M387484 <HTML><HEAD></HEAD><BODY><P>What does the following script will do if the MonthYear values are like '8-2014' , '11-2013' , '2-2015'. </P><P></P><P><SPAN style="color: #0000ff;">MonthStart</SPAN>(<SPAN style="color: #0000ff;">Date</SPAN>(<SPAN style="color: #0000ff;">Date</SPAN>(<SPAN style="color: #0000ff;">Date#</SPAN>(<SPAN style="color: #993366;">MonthYear</SPAN>,'MM-YYYY'),'MM-YYYY'),'YYYYMM')) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #993366;">P</SPAN></P><P></P><P></P><P>-James</P></BODY></HTML> Thu, 06 Oct 2016 12:06:41 GMT https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205258#M387484 2016-10-06T12:06:41Z Re: Nested Date functions https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205259#M387485 <HTML><HEAD></HEAD><BODY><P>Not sure if you need all that, this should be fine and give the same result</P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;"><STRONG>MonthStart</STRONG></SPAN><STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Date#</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993366;">MonthYear</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">,'MM-YYYY')) </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">as</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> </SPAN></STRONG><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993366;"><STRONG>P</STRONG></SPAN></P></BODY></HTML> Thu, 06 Oct 2016 12:10:07 GMT https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205259#M387485 sunny_talwar 2016-10-06T12:10:07Z Re: Nested Date functions https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205260#M387486 <HTML><HEAD></HEAD><BODY><P>what date# does here ? Examples in the help are not clear. Please clarify.</P></BODY></HTML> Thu, 06 Oct 2016 12:22:55 GMT https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205260#M387486 2016-10-06T12:22:55Z Re: Nested Date functions https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205261#M387487 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlikview.com/thread/97020" title="https://community.qlikview.com/thread/97020">Date() vs Date#() | Qlik Community</A></P></BODY></HTML> Thu, 06 Oct 2016 12:32:48 GMT https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205261#M387487 lakshmikandh 2016-10-06T12:32:48Z Re: Nested Date functions https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205262#M387488 <HTML><HEAD></HEAD><BODY><P>It is an interpretation function. When QlikView is unable to understand a particular date format, we can use Date#() to help it understand the format the date is in.</P><P></P><P>Does that make sense?</P></BODY></HTML> Thu, 06 Oct 2016 12:37:51 GMT https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205262#M387488 sunny_talwar 2016-10-06T12:37:51Z Re: Nested Date functions https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205263#M387489 <HTML><HEAD></HEAD><BODY><P>I encourage you to read these blogs:</P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Thu, 06 Oct 2016 12:38:37 GMT https://community.qlik.com/t5/QlikView/Nested-Date-functions/m-p/1205263#M387489 sunny_talwar 2016-10-06T12:38:37Z