Hi Community,
Had a question that I was hoping you all could share some light on. I'm trying to create a field that is a range of dates and am having some problems. I'd like to create a two week range starting on 1/6/2013 that goes from Sunday - Satruday of the following week. I've created a short example of the date and the field I'd like to create.
I've been trying to use the weekstart and weekend function without any success. I've tried using variables and looping through the recrod set but haven't landed on anytihng that works the way I want it to yet.
Any ideas on how to create something like this? Any builit in functions that can help?
Thanks
| Date | Range |
| 1/6/2013 | 1/6 - 1/19 |
| 1/7/2013 | 1/6 - 1/19 |
| 1/8/2013 | 1/6 - 1/19 |
| 1/9/2013 | 1/6 - 1/19 |
| 1/10/2013 | 1/6 - 1/19 |
| 1/11/2013 | 1/6 - 1/19 |
| 1/12/2013 | 1/6 - 1/19 |
| 1/13/2013 | 1/6 - 1/19 |
| 1/14/2013 | 1/6 - 1/19 |
| 1/15/2013 | 1/6 - 1/19 |
| 1/16/2013 | 1/6 - 1/19 |
| 1/17/2013 | 1/6 - 1/19 |
| 1/18/2013 | 1/6 - 1/19 |
| 1/19/2013 | 1/6 - 1/19 |
| 1/20/2013 | 1/20 - 2/2 |
| 1/21/2013 | 1/20 - 2/2 |
| 1/22/2013 | 1/20 - 2/2 |
| 1/23/2013 | 1/20 - 2/2 |
| 1/24/2013 | 1/20 - 2/2 |
| 1/25/2013 | 1/20 - 2/2 |
| 1/26/2013 | 1/20 - 2/2 |
| 1/27/2013 | 1/20 - 2/2 |
