You can use DOW() to figure out the day of the week. I think Sunday is 0. (VFP Help will tell you). Then you can use date math, DATE()-14 for two weeks ago.


>Hi guys,
>
>I need the previous week date range (mon-sun), for example if I run the program today thursday 5/2/2013, it will return the range for the previous week 4/22 - 4/28, I will run the program on mondays so if I would have ran it this monday would have returned 4/22 - 4/28 as well. I need to get the date range from 2 weeks ago as well.
>
>Thanks!