topic Re: Date fields & Joins in QlikView https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389090#M820126 <HTML><HEAD></HEAD><BODY><P>Perfect- thank you!</P></BODY></HTML> Fri, 11 Aug 2017 13:19:35 GMT 2017-08-11T13:19:35Z Date fields & Joins https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389088#M820124 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have the following situation:</P><P></P><P>Excel 1</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Username</TH></TR><TR><TD style="padding: 2px;">13/02/2017</TD><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">14/02/2017</TD><TD style="padding: 2px;">B</TD></TR></TBODY></TABLE><P></P><P>Excel 2</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Created On</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Project</TH></TR><TR><TD style="padding: 2px;">13/02/2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">13/02/2017</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE><P></P><P>I want it so that on the dashboard when i filter on 13/02/2017 it filters by both Date and Created On. </P><P></P><P>I think i need to join the two date fields together. </P><P></P><P>Can you help?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389088#M820124 2020-11-25T16:16:04Z Re: Date fields & Joins https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389089#M820125 <HTML><HEAD></HEAD><BODY><P>Check here:</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Fri, 11 Aug 2017 13:15:03 GMT https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389089#M820125 sunny_talwar 2017-08-11T13:15:03Z Re: Date fields & Joins https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389090#M820126 <HTML><HEAD></HEAD><BODY><P>Perfect- thank you!</P></BODY></HTML> Fri, 11 Aug 2017 13:19:35 GMT https://community.qlik.com/t5/QlikView/Date-fields-Joins/m-p/1389090#M820126 2017-08-11T13:19:35Z