All orders in current week

[roccoau]

Hi I am looking for a formula for my query which filters out only the orders raised in the current week.(5day week Monday to Friday) I did not want to enter dates manualy.
Can this be done ?
Can anyone help me with this.

Tks

 

[RuralGuy]

Maybe this MVP's page will help. A plethora of date functions

 

[roccoau]

Thanks this site should help me.

Rgds

 

[RuralGuy]

You are welcome.