Jeremy_Tan - profile

Jeremy_Tan · Apr 30, 2020

Hey everyone, I am having trouble creating a formula that would help me with product listings with different expiry dates. My products come in packages of sessions with differing expiry dates. How do I get a formula that would help me get the expirat...

Jeremy_Tan · May 05, 2020

Justin_Barrett: DATEADD({Date of Sale}, VALUE(LEFT({Validity period} & “”, 2)), ‘days’) woah this works well tooooo! So glad! thank you!

Jeremy_Tan · May 01, 2020

OMGOSH THANKS! It worked! i had used this formula recently but it couldnt work because my validity period was a Lookup and not a number field. Didn’t know that was what was blocking the formula from working! THANKS!

Jeremy_Tan · Apr 30, 2020

have you found a solution?

User Statistics

User Activity

Formula for multiple products with different Expiry dates

Re: Formula for multiple products with different Expiry dates

Re: Formula for multiple products with different Expiry dates

Re: Membership Expiry calcuation European date format and Picking most recent transaction