LastFullWeek Formula 2

[jdaily]

Hi All,

I got this formula from Synapsevampire and wanted to know how I would be able to show the actual start and end date of the particular week? For example: Jan. 12, 2004 to Jan. 18, 2004.

BTW: Thanks Synapse for the formula!

synapsevampire (Programmer) Jun 18, 2002
Here's one way:

{MyTable.MyDateField} in minimum(lastfullweek)+1 to maximum(lastfullweek)+1


Thanks in advance!

John

 

[bdreed35]

Create a formula like this to create your display

ToText((minimum(lastfullweek)+1),"MMM. dd, yyyy") + " to " + ToText((maximum(lastfullweek)+1),"MMM. dd, yyyy")

~Brian

 

[jdaily]

Thanks Brian! This works perfect!

John