Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Function 1

Status
Not open for further replies.

metalboy

Technical User
Apr 1, 2004
97
GB
Hi I am wondering you can stipulate the day's in a week similar to the Week to date from Sunday Function,

Day order would be

M,T,W,T,F,S,S

Thanks

“It is a mistake to think you can solve any major problems just with potatoes.”
Douglas Adams
 
I guess you mean the starting day of the week.

Try a formula containing:

datepart("ww",{table.date},2)

for grouping data into weeks starting with Monday.

Otherwise post specifics of your intent.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top