Hello, I'm stuck trying to figure out how many workdays exist in a given month. It is easy enough to get the number of workdays between a start and end date using the WORKDAY_DIFF() function, and it also seems possible to collect the total number of ...
Hello, I'm trying to figure out how I might be able to extract a portion of string relative to the position of a delimiter or other character.For example, I have a table of Events that are structured as follows:##### | <Name of Event>.I want to be ab...
After through the documentation on DATETIME_PARSE() I’m not seeing the timezone respected when used in conjunction with either SET_LOCALE() or SET_TIMEZONE() for conversion of a string field containing date and time information. What am I missing her...
I have table where I’m tracking attendance versus enrollment of a training workshop. I’m using a name field that also has a lookup field displaying whether someone goes by a formal name or an alias. I have another field that has an array of all atten...
I have a Learning Course table that tracks courses with either a single session or dual sessions via checkbox fields. I have links to fields in this table that identify whether an enrollee has completed the relevant sessions(s). From there I have a c...
Thanks for that Adam. A much cleaner approach to getting total workdays per month than what I tried! But, I'm trying to build out not just the total workdays per month; I'm trying to to build out the number of workdays in each month based on when a p...
Thanks Jody,I have a table with a list of projects, each with a start and end date as well as total number of hours. The day of the month for both start and end dates vary depending on the project. While it's easy enough to obtain the number workdays...
Thanks for your reply @bruceconsulting . In the meantime since I posted, I ended up creating a version of one of your suggestions, using the FIND() command since there is variability in the number of characters preceding and following the vertical ba...
