i have a value lets say its: 24544 I obtain this information from data set to populate the value of one of my columns. i want to display it in my report as:
- W: 2
- D: 3
- H: 1
- M: 4
i've tried
=Format(DateAdd("n", Fields!Downtime.Value, "00:00:00"), "wk:dd:HH:mm")
but it does not accept ww
or wk
and exceeds number of days above 7 (which should increase the counter of weeks instead). I work in VS 2010 How can i achive this?