Last Week formula

[Bikeman17]

Hi gurus,

I am looking for a calculation that will display this result: 10/23/2005...10/29/2005. In fact, last week based on today. The result will change as time goes by.

I know it has to do with DateToText(Today.... but I can't figure out the rest.

[Bikeman17]

Well, I guess I made it.

DateToText((Today-7)- (DayofWeek(Today)-1)) & "..." & DateToText(Today- (DayofWeek(Today)))

[-Queue-]

If the calculation is used in a script step, then Today will work fine (although it is no longer available after version 6). If used for a calculation field, and you want the value to automatically update when the field is unstored, use

DateToText(Status(CurrentDate) - DayofWeek(Status(CurrentDate)) - 6) & "..." & DateToText(Status(CurrentDate) - DayofWeek(Status(CurrentDate)))