Thursday 10 March 2011

Get week commencing date

If you want a week commencing date of Monday.... 


tmp := @Weekday(Date); 
@Date(@If(tmp>1;@Adjust(Date;0;0;2-tmp;0;0;0);@Adjust(Date;0;0;-5;0;0;0)))

No comments:

Post a Comment