Solved Format Function to get current week or current quarter data (1 Viewer)

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 05:43
Joined
Feb 28, 2001
Messages
22,564
Don't forget when working on "week of year" that there are two relevant but optional arguments for FORMAT when dealing with dates.


Note also that, as is typical for Office library functions, the return value is a Variant string. Which means that in expressions, it is eminently convertible by the compiler to whatever is needed by the given expression in which it appears.
 

Users who are viewing this thread

Top Bottom