Testing for Number of Weeks
I have a numeric field 'weeks' I have used to work out number of weeks between two dates. Works fine. I am then using following statements in a formula text field to allocate certain text values. b...
Forum Discussion
Thank you so much. It works great. I was expecting a categorisation based on the weeks test. I created the week numbers as numeric field but to convert to these to weeks, I ToWeeks" in the week formula. May be I should remove the ToNumber from the formula.