Cody_Winchester - profile

Cody_Winchester · Jan 30, 2023

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...

Cody_Winchester · Aug 26, 2022

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...

Cody_Winchester · Aug 19, 2022

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...

Cody_Winchester · Aug 17, 2022

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...

Cody_Winchester · Aug 09, 2022

I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to b...

Cody_Winchester · Jan 30, 2023

Much more elegant! Thanks so much Jody!

Cody_Winchester · Jan 30, 2023

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...

Cody_Winchester · Aug 26, 2022

Nevermind. Removing the input format and locale options returns the correct information: DATETIME_PARSE({Completed At (PST/PDT)})

Cody_Winchester · Aug 22, 2022

Hi @Kamille_Parks , the REGEX worked! Thanks for that! What I had meant before of having “no effect” was that the CONCATENATE operator, “&,” didn’t produce any different results. I appreciate your time!

Cody_Winchester · Aug 22, 2022

Thanks for your reply @Kamille_Parks. Unfortunately, this has no effect. I need to FIND either one or the other strings (Alias, or Name) within the Workshop Session Attendance field (which is an array of multiple linked records). Do you have any othe...

User Statistics

User Activity

Formula to extract portion of String at Delimiter/Character

DATETIME_PARSE() not respecting timezone

Use FIND() to look for two strings in an array

Formula with OR and AND criteria

Time from DATE_FORMAT() is incorrect

Re: Formula to extract portion of String at Delimiter/Character

Re: Formula to extract portion of String at Delimiter/Character

Re: DATETIME_PARSE() not respecting timezone

Re: Use FIND() to look for two strings in an array

Re: Use FIND() to look for two strings in an array