PaulPeterson2
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: IF statement changing numeric to text
What output are you getting in the field? I do see some issues with the formulam but would like to know what results you are currently seeing. Also, what is the field type for Time in Role? Initial observation: Condition 1 should be [Time in Role] < 1 if you are looking for less than a year. currently you will get 1 year and less The other conditions should follow this format: [Time in Role] > year and [Time in Role] <= end year This is untested, but should get you pointed in the right direction33Views0likes2CommentsRe: How do I define work days
Sorry, just noticed an error. Try This instead: If(DayOfWeek(startDate) > 3, 0, ToDays(NextDayOfWeek(startDate, 3) - startDate)) + (Int(ToDays(If(ToDays(endDate - NextDayOfWeek(endDate, 0)) = 7, endDate, NextDayOfWeek(endDate, 0)) - If(ToDays(NextDayOfWeek(startDate, 6) - startDate) = 7, startDate, NextDayOfWeek(startDate, 6))) / 7) * 4 )+ If(DayOfWeek(endDate) > 3, 0, ToDays(endDate - PrevDayOfWeek(endDate, 0))) ------------------------------ Paul Peterson ------------------------------32Views0likes0CommentsRe: How do I define work days
This should give you a good starting point: If(DayOfWeek(endDate) > 3, 0, ToDays(NextDayOfWeek(startDate, 3) - startDate)) + (Int(ToDays(If(ToDays(endDate - NextDayOfWeek(endDate, 0)) = 7, endDate, NextDayOfWeek(endDate, 0)) - If(ToDays(NextDayOfWeek(startDate, 6) - startDate) = 7, startDate, NextDayOfWeek(startDate, 6))) / 7) * 4 )+ If(DayOfWeek(endDate) > 3, 0, ToDays(endDate - PrevDayOfWeek(endDate, 0))) ------------------------------ Paul Peterson ------------------------------7Views0likes1CommentRe: Categories & SubCategories
How are the fields populated? If they are text multiple choice you can accomplish it using dynamic form rules, a better idea would be to have the a child table to generate the categories. The dynamic drop down will be easier to maintain and update. ------------------------------ Paul Peterson ------------------------------5Views0likes0Comments