<div>
Week: Val(Format([TblALC]![Date]<wbr />,&quot;ww&quot;))<br />
<br />
or &nbsp;<br />
week:Datepart(&quot;ww&quot;,[TblALC<wbr />]![Date])<br />

</div>


Week: Val(Format([TblALC]![Date],"ww"))

or  
week:Datepart("ww",[TblALC]![Date])


<div>
Thanks worked great, sorry for late reply.
</div>


Thanks worked great, sorry for late reply.

<div>
Glad to be of assistance.<br />
<br />
AW
</div>


<div>
<div class="content wysiwyg-content">
Dear experts,<br />
<br />
I have converted a date column in access to week using the following:<br />
<br />
Week: Format([TblALC]![Date],&quot;ww<wbr />&quot;)<br />
<br />
The problem I have is that after the conversion the returned column is a &quot;text&quot; column not a &quot;number&quot; column. this means when i compare it to tables setup already with the week number in as a &quot;number&quot; format i get a data type mismatch error.<br />
<br />
Is there any way to solve this problem.<br />
<br />
Regards<br />
<br />
Ritesh
</div>
</div>


Dear experts,

I have converted a date column in access to week using the following:

Week: Format([TblALC]![Date],"ww")

The problem I have is that after the conversion the returned column is a "text" column not a "number" column. this means when i compare it to tables setup already with the week number in as a "number" format i get a data type mismatch error.

Is there any way to solve this problem.

Regards

Ritesh

Format of week column - converted from date column

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.