BlackO - profile

BlackO · Oct 25, 2018

Hi, im using Airtable to calculate invoice dated from when a client signs up depending on payment method and type. I have a start date, and i have a last invoice date and next invoice date. And im using a formula now to calculate next invoice date ba...

BlackO · Oct 26, 2018

I finally managed to figure it out: IF( {Last Invoice Date} = BLANK(),DATETIME_FORMAT(Start, 'YYYY-MM-DD'),( DATETIME_FORMAT( DATEADD( {Last Invoice Date}, SWITCH( {Payment M...

BlackO · Oct 26, 2018

I just tested and it works perfectly! BUT I realize I made an error in my thinking. If the Last Invoice Date is empty, and Start date is used, there should be no DATEADD (or 0) so its same invoice date as the start date. That’s why I was doing the co...

BlackO · Oct 25, 2018

Wow! Thanks, i would have never figured that out. I will try this tomorrow and get back to you.

BlackO · May 28, 2018

+1 duplicate detection I need to be able to make sure a value in a table is unique. Its used to handle ID tags, and we need an easy way to detect if a tag already has been assigned to someone, without having to do a search every time.

User Statistics

User Activity

Help with complex IF formula with DATEAD and DATETIME_FORMAT

Re: Help with complex IF formula with DATEAD and DATETIME_FORMAT

Re: Help with complex IF formula with DATEAD and DATETIME_FORMAT

Re: Help with complex IF formula with DATEAD and DATETIME_FORMAT

Re: [SOLVED] Record Duplication Detection, Deduping, and Duplicate Merging