Beginning of week

J

Jaz

Is there a formula that can tell me what the beginning of the week is? For
example, Today is 4/10/07. The beginning of our week is Sunday so I want it
to return a value of 4/8/07.

Thanks,
Jasper
 
K

KARL DEWEY

Replace [IncidentDate] with your date field.

DateAdd("d",-Format([IncidentDate]-1,"w"),[IncidentDate])
 
J

Jaz

THANKS!
KARL DEWEY said:
Replace [IncidentDate] with your date field.

DateAdd("d",-Format([IncidentDate]-1,"w"),[IncidentDate])
--
KARL DEWEY
Build a little - Test a little


Jaz said:
Is there a formula that can tell me what the beginning of the week is? For
example, Today is 4/10/07. The beginning of our week is Sunday so I want it
to return a value of 4/8/07.

Thanks,
Jasper
Click to expand...
Click to expand...
 
Top