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 ??

bananAsked:
Who is Participating?
 
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:
Edited text of question
0
 
bananAuthor Commented:
Thanx.
Have a nice christmas!
Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.