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

Maybe this MVP's page will help. A plethora of date functions (http://www.pacificdb.com.au/MVP/Code/Dates.htm)

Thanks this site should help me.

Rgds

You are welcome.