Steve_Vo - profile

Steve_Vo · Jul 13, 2019

How would you write a date time formula for Beginning of current month to End of current month? The trick is, it’s the current month and the month always changes. Any Jedi out there?

Steve_Vo · Aug 06, 2019

Justin, It works, thanks a million!

Steve_Vo · Aug 06, 2019

Hi Justin, I’ve tried your revised formula but got an error message. What’s missing? VALUE(TRIM(RIGHT(SUBSTITUTE(LEFT(Expenses Accounts, LEN(Expenses Accounts) - 2), " “, REPT(” ", 10)), 12)))

Steve_Vo · Aug 06, 2019

Hi Justin, How would you re-write the code so that it will works my other text lines that ending with A, S or something else? I have all these in the same field.

Steve_Vo · Aug 06, 2019

Justin, You are an Airtable Jedi! The force are with you, it works!

Steve_Vo · Aug 05, 2019

I knew it would be a challenge, thanks for your help!

User Statistics

User Activity

Date time challenge & Nested Ifs formula solved?

Re: Formula for extracting last text/digits from a code

Re: Formula for extracting last text/digits from a code

Re: Formula for extracting last text/digits from a code

Re: Formula for extracting last text/digits from a code

Re: Formula for extracting last text/digits from a code