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)




      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.



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


      Please Help.


      Thank you.