topic Re: how to get 1st april date from today function in QlikView https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400777#M459326 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>=date(Today(),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">MM/DD/YYYY</SPAN>')</P></BODY></HTML> Thu, 05 Oct 2017 10:38:53 GMT Chanty4u 2017-10-05T10:38:53Z how to get 1st april date from today function https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400776#M459325 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P> how to get 4/1/2017(MM/DD/YYYY)date format&nbsp;&nbsp; using today() function when a fiscal year 2018 is selected </P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 05 Oct 2017 10:33:27 GMT https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400776#M459325 kunkumnaveen 2017-10-05T10:33:27Z Re: how to get 1st april date from today function https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400777#M459326 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>=date(Today(),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">MM/DD/YYYY</SPAN>')</P></BODY></HTML> Thu, 05 Oct 2017 10:38:53 GMT https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400777#M459326 Chanty4u 2017-10-05T10:38:53Z Re: how to get 1st april date from today function https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400778#M459327 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P>=YearStart(Today(),0,4)</P><P></P><P>Or </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=date(Today(),'</SPAN><SPAN style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">MM/DD/YYYY</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">')</SPAN></P></BODY></HTML> Thu, 05 Oct 2017 10:46:08 GMT https://community.qlik.com/t5/QlikView/how-to-get-1st-april-date-from-today-function/m-p/1400778#M459327 prma7799 2017-10-05T10:46:08Z