Mark week number

[#1]

Hi all,

This might be rather a simple one but I couldn't get this to work.

I have two date fields from two different table and I populated a new field call timegap using the difference of two date fields. Now i want to create a week field which will be based on timegap field. so if the timegap is 1-7 its week 1, 8-14 its week 2 etc upto week 12 .

Thank you

Naveen

[sunny_talwar · Accepted solution]

May be like this

'Week ' & Ceil(timegap/7) as NewField

[#3]

That worked. Thanks