## Conversations

###### Counting Months based on two date field with rounding
Hi, Need some help with a formula to count the number of months by referencing start and end date fields. I need this to round to the nea...
• 1 me too
• 3 replies
• Question
• In Progress
###### Formula to Generate Which week of the year it is based on date entered in "Process Date" Field.
In search of Formula to Generate Which week of the year it is based on date entered in "Process Date" Field. I tried one and it is tellin...
• 1 me too
• 17 replies
• Question
###### add duration to an event
Hello. I am trying to create a calendar that gives preliminary duration times to events that have expected dates, but no actual dates. Fo...
• 1 me too
• Question
• In Progress
• 1 me too
• 4 replies
• Question
• In Progress
###### Adding child records from multiple parent records
Is is possible to do this? I have a parent table of Students related to a table of Attendances. I want to select a group of students  who...
• 1 me too
• 2 replies
• Question
• In Progress
###### WorkdayAdd trouble with my formula field
I am looking for help with my formula. It is in a formula date fieldWorkdayAdd(ToWorkDate(ToDate("[Factory Order - Order Date]")), 91) Q...
• 1 me too
• 4 replies
• Question
###### Report on Recurring Dates Annually?
I am trying to create a report that shows "Birthdays within the next 7 days" and "Anniversaries This Quarter" and I am hitting a brick wa...
• 1 me too
• 4 replies
• Question
###### Help with formula
My requirements were the following: Program = ResidentialMeasure = M&V and any of these: M&V_allclean = No TO_CalculatedCFMPerTon < 3...
• 1 me too
• 2 replies
• Question
• In Progress
###### Cannot figure out syntax to display a time of day in a formula text field
So I have a time of day formula that I am trying to put into a formula text field in my form. Here is the formula that I have written. I...
• 1 me too
• 4 replies
• Question
###### Formula Duration in Hours
I am importing a .csv file with two date columns. The date columns are formatted Date & Time.  I need a formula that calculates the num...
• 1 me too
• Question
I need help with my current formula.  Right now, it returns "OVERDUE" if a report is not presented in time.  The issue is that I need the...
• 1 me too
• 6 replies
• Question