hrdpgajjar
Registered User.
- Local time
- Today, 08:08
- Joined
- Sep 24, 2019
- Messages
- 51
Hi all,
I need to get report of material sent by current week with a query. I am able to get report of current month by following funtion,
Format([Material Sent Date], "yyyymm") - by this function I am able to get current month data and,
Format([Material Sent Date], date()) - by this function I am able to get current date (todays date) data
but I need to get data of current week and current quarter by the above function.
Please help how can I do that.
Thank you,
I need to get report of material sent by current week with a query. I am able to get report of current month by following funtion,
Format([Material Sent Date], "yyyymm") - by this function I am able to get current month data and,
Format([Material Sent Date], date()) - by this function I am able to get current date (todays date) data
but I need to get data of current week and current quarter by the above function.
Please help how can I do that.
Thank you,