• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Differences between Format and Datepart ?

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
banan
Asked:
banan
  • 2
1 Solution
 
bananAuthor Commented:
Edited text of question
0
 
Victor SpiridonovCommented:
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
 
bananAuthor Commented:
Thanx.
Have a nice christmas!
Regards
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now