Solved

Differences between Format and Datepart ?

Posted on 1998-12-23
3
202 Views
Last Modified: 2006-11-17
Hello,
What  are the differences between this two lines (used in a query):
Format([Timeperiod];"ww")

DatePart("ww";[Timeperiod])

??
When and where do I use Format and DatePart ??

0
Comment
Question by:banan
  • 2
3 Comments
 

Author Comment

by:banan
ID: 1971937
Edited text of question
0
 
LVL 7

Accepted Solution

by:
spiridonov earned 30 total points
ID: 1971938
From the point of displaying values there is no difference, you can use both. Though Format should be used only for displaying values and returns String , Datepart can be used in calculations and returns integer.


0
 

Author Comment

by:banan
ID: 1971939
Thanx.
Have a nice christmas!
Regards
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now