https://community.qlik.com/t5/App-Development/Convert-string-to-date/m-p/1567733#M41417 <P>Hi there</P><P>Try Date#([Field Name],'YYYY-MM')</P><P>Good luck.</P><P>Mauritz</P> Wed, 10 Apr 2019 14:42:40 GMT Mauritz_SA 2019-04-10T14:42:40Z https://community.qlik.com/t5/App-Development/Convert-string-to-date/m-p/1567727#M41416 <P>Hi,</P><P>I have a standard calendar date field in the format of MM/DD/YYYY.</P><P>I created a fiscal month field and a fiscal year field off of the calendar date above.</P><P>Then I merged the fiscal year and fiscal month together to create a field that looks like 'YYYY-MM'.&nbsp; This field is a string and I need to convert it to a date.</P><P>Thank you,</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:04:39 GMT https://community.qlik.com/t5/App-Development/Convert-string-to-date/m-p/1567727#M41416 hjm35055 2024-11-16T21:04:39Z https://community.qlik.com/t5/App-Development/Convert-string-to-date/m-p/1567733#M41417 <P>Hi there</P><P>Try Date#([Field Name],'YYYY-MM')</P><P>Good luck.</P><P>Mauritz</P> Wed, 10 Apr 2019 14:42:40 GMT https://community.qlik.com/t5/App-Development/Convert-string-to-date/m-p/1567733#M41417 Mauritz_SA 2019-04-10T14:42:40Z