Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2006

Tip: Looking for answers? Try searching our database.

Grouping using Report Wizard: Date Format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kvc - 12 Dec 2006 16:13 GMT
What do the zeros mean???

=Format$([VisDate],"mmm yyyy",0,0)
RoyVidar - 12 Dec 2006 16:35 GMT
"kvc" <kvc1234@gmail.com> wrote in message
<1165939995.169522.27990@73g2000cwn.googlegroups.com>:
> What do the zeros mean???
>
> =Format$([VisDate],"mmm yyyy",0,0)

The first zero is passed as the FirstDayOfWeek arguement of the Format
function, which means the format function will use the system setting
(regional settings, I suppose), to determine what is the first day of
week. On my setup, that would be Monday, while in the US, I suppose it
would be Sunday. Sunday is default for this function, if nothing is
specified for this arguement.

The second zero is passed as the FirstWeekOfYear arguement of the
Format function, which means the Format function will sue the system
setting (regional settings, I suppose), to determine what is the first
week of the year. Start with week in which January 1 occurs, is the
default, if nothing is specified for this arguement.

To find out more about such, hit ctrl+g to to get the immediate pane,
type the function name, then hit F1 while the cursor is within the
name of the function.

Signature

Roy-Vidar

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.