how to get week no's on monthwise

[#1]

Hi guys,

In edit script i am using...... ceil(Week([Inception Date]))as Week, to get week no...which is working properly...

But my query is i want the week number on monthwise

like if it is a 1st week of june then it should show 1 rather then 22nd week...if its 3rd week then it should show 3 rather then 24th week...and same  for rest...

thanx and regards,

hitesh

[marcus_sommer · Accepted solution]

perhaps so:

ceil(day([Inception Date]) / 7 ) as Week

- Marcus