Week Commencing

[Shin25]

Hi All

Iam using CRXI Rel 2, I have a dt field which is populated according to when activity happened. But what I want to know is how do I get the weekcommencing date from that dt field. For eg. dt from the field is 10/01/08, the week commencing date would be 06/01/08.

I hope I make sense...

Please ask if I have missed anything.

Many Thanks

 

[lbass]

You should always identify the formatting of your dates to clarify what are months vs. days. Anyway, use:

{table.date}-dayofweek({table.date})+1

-LB