https://community.qlik.com/t5/App-Development/Qlikview-text-format-to-date-format/m-p/2143683#M93059 <P>Hi all Qlikview users,</P> <P>I want to convert [YearMonth] field to Date format.</P> <P>I have tried this function in Qlikview object dimension "<SPAN>=Date(Date#([YearMonth], 'YYYY-MM'), 'MMM YYYY')".</SPAN></P> <P><SPAN>The result showed Nov 2023, it look correct. However when the trigger email to user, the date column in excel file is</SPAN></P> <P><SPAN> in Text data type.&nbsp; Can anyone advise me how should I do in order to let the date column show in date format instead </SPAN></P> <P><SPAN>when Qlikview trigger email.</SPAN></P> <P><SPAN>Thanks everyone!</SPAN></P> Mon, 04 Dec 2023 03:21:03 GMT CM-1 2023-12-04T03:21:03Z https://community.qlik.com/t5/App-Development/Qlikview-text-format-to-date-format/m-p/2143683#M93059 <P>Hi all Qlikview users,</P> <P>I want to convert [YearMonth] field to Date format.</P> <P>I have tried this function in Qlikview object dimension "<SPAN>=Date(Date#([YearMonth], 'YYYY-MM'), 'MMM YYYY')".</SPAN></P> <P><SPAN>The result showed Nov 2023, it look correct. However when the trigger email to user, the date column in excel file is</SPAN></P> <P><SPAN> in Text data type.&nbsp; Can anyone advise me how should I do in order to let the date column show in date format instead </SPAN></P> <P><SPAN>when Qlikview trigger email.</SPAN></P> <P><SPAN>Thanks everyone!</SPAN></P> Mon, 04 Dec 2023 03:21:03 GMT https://community.qlik.com/t5/App-Development/Qlikview-text-format-to-date-format/m-p/2143683#M93059 CM-1 2023-12-04T03:21:03Z https://community.qlik.com/t5/App-Development/Qlikview-text-format-to-date-format/m-p/2143887#M93068 <P>Try it with a real date from the data-model. This means each day is set to 1 and the formatting is set to the Excel default-format for the users region.</P> Mon, 04 Dec 2023 12:27:55 GMT https://community.qlik.com/t5/App-Development/Qlikview-text-format-to-date-format/m-p/2143887#M93068 marcus_sommer 2023-12-04T12:27:55Z