11 Replies Latest reply on Jan 21, 2019 4:41 PM by Shinichiro Murakami

    find beginning/start of week by any given date (Use in Join)

    NAYANA MADHEKAR

      Hello,

       

      Table1: I have a range of Daily Dates.(work date in Image)Example, 01/06/2019, 01/07/2019, 01/08/2019, 01/09/2019,01/10/2019,01/11/2019,01/12/2019,

       

      Table 2: I need to join it to another table that has only Week Starting dates 01/06/2019.For week (01/06/2019-01/12/2019)

       

      I need to join these two tables at the connection Level.

       

      1.PNG

      Can I create a calculated field for Table1 that would help me join them????

       

      Please Help.

       

      Thank you.