I am looking to convert two dates to link them. One date is in 'MMM-YYYY' format, i want to keep this format. The second date im pulling from excel is in mmm-yy format(Checked it form Format Cells- Custom). Any help on how i can convert it into MMM-YYYY. Ive tried Date#(Date#(TransMonthYr,'mmm-yy'), 'MMM-YYYY'). Doesnt seem to be working, any hints ?
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
