topic Re: different format in date in QlikView https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953362#M953695 <HTML><HEAD></HEAD><BODY><P>Can you post a qvw and qvd instead of posting a rar file?</P><P></P><P>Generally you can try joining them on by creating a new field may be like this:</P><P></P><P><STRONG>MonthName(OneDateField) as DateToBeJoined</STRONG></P><P></P><P><STRONG>MonthName(TwoDateField) as DateToBeJoined</STRONG></P></BODY></HTML> Fri, 20 Nov 2015 18:51:20 GMT sunny_talwar 2015-11-20T18:51:20Z different format in date https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953361#M953694 <HTML><HEAD></HEAD><BODY><P>Hi expert, i have a situation:</P><P></P><P>I have a month year column and two tables that are relation by this field</P><P></P><P>between this two table the values are the same , but do not match </P><P></P><P>i attached an image explain, i believe that is the format but is the totaly the same</P><P></P><P>attached the qvw and the qvd for example, thank you a lot</P><P></P><P>Fernando K.</P></BODY></HTML> Fri, 20 Nov 2015 18:49:34 GMT https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953361#M953694 fkeuroglian 2015-11-20T18:49:34Z Re: different format in date https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953362#M953695 <HTML><HEAD></HEAD><BODY><P>Can you post a qvw and qvd instead of posting a rar file?</P><P></P><P>Generally you can try joining them on by creating a new field may be like this:</P><P></P><P><STRONG>MonthName(OneDateField) as DateToBeJoined</STRONG></P><P></P><P><STRONG>MonthName(TwoDateField) as DateToBeJoined</STRONG></P></BODY></HTML> Fri, 20 Nov 2015 18:51:20 GMT https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953362#M953695 sunny_talwar 2015-11-20T18:51:20Z Re: different format in date https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953363#M953696 <HTML><HEAD></HEAD><BODY><P>Hi sunny, thks</P></BODY></HTML> Fri, 20 Nov 2015 18:53:37 GMT https://community.qlik.com/t5/QlikView/different-format-in-date/m-p/953363#M953696 fkeuroglian 2015-11-20T18:53:37Z