- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hello @SorenDahk ,
it's because SQL performs integer division.
you have to ''trick'' sql into thinking that on your division ther is at least one float.
Try this : ToDouble(151)/7
or this with your formula : Ceil(ToDouble((WeekDay(GetDate())+1 + DayOfYear(GetDate()))) / 7)
results :
Br,