topic Re. :Re: Re. :Yet another date question... in QlikView https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171345#M41384 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Year(Date)&amp;'-'&amp;num(Month(Date)) as [%CurrencyPeriod]</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 31 May 2010 17:15:47 GMT martin59 2010-05-31T17:15:47Z Yet another date question... https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171342#M41381 <HTML><HEAD></HEAD><BODY><P>Hello all!</P><P>I have a question regarding dates. I have an excel with a date column ' 2010-04-01' and I would like to use the year and month from this field so I would like to have '2010-04'. I thought this would be the solution but it doesn't work:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />date(date#(left(Date, 7), 'YYYY-MM'), 'YYYY-MM') as %CurrencyPeriod<BR /></PRE><BR /><BR /> <P>This results in a '-'</P><P>Any suggestions of how I could do this?</P><P>Br</P><P>Cristian</P></BODY></HTML> Mon, 31 May 2010 16:56:11 GMT https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171342#M41381 2010-05-31T16:56:11Z Re. :Yet another date question... https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171343#M41382 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I think you have to use this expression :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Year(Date)&amp;'-'&amp;Month(Date) as [%CurrencyPeriod]</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 31 May 2010 17:04:19 GMT https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171343#M41382 martin59 2010-05-31T17:04:19Z Re. :Yet another date question... https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171344#M41383 <HTML><HEAD></HEAD><BODY><P>Thank you but this results in: '2010-apr'. How can I convert the month to a number?</P><P></P><P>Br</P><P>Cristian</P></BODY></HTML> Mon, 31 May 2010 17:11:18 GMT https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171344#M41383 2010-05-31T17:11:18Z Re. :Re: Re. :Yet another date question... https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171345#M41384 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Year(Date)&amp;'-'&amp;num(Month(Date)) as [%CurrencyPeriod]</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 31 May 2010 17:15:47 GMT https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171345#M41384 martin59 2010-05-31T17:15:47Z Re. :Re: Re. :Yet another date question... https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171346#M41385 <HTML><HEAD></HEAD><BODY><P>Great! Thank you!</P><P>Br</P><P>Cristian</P></BODY></HTML> Mon, 31 May 2010 17:26:38 GMT https://community.qlik.com/t5/QlikView/Yet-another-date-question/m-p/171346#M41385 2010-05-31T17:26:38Z