Erik_Peterson - profile

Erik_Peterson · Aug 24, 2022

I was tring to modify a formula DATEADD({Start Date},13,‘days’) to find the end of the month but since months have differing amounts of days I wasn’t sure how I could do that. Bascially, I want the formula look at the start date and then output the l...

Erik_Peterson · Sep 20, 2018

I have two tables (Ad Schedule & Ad Copy). Ad Schedule contains rows of ads (linked records to ‘Ad Copy’ along with lookup columns) with dates when the ads went live. The Ad Copy table contains the ad content that the Ad Schedule table pulls from. I ...

Erik_Peterson · Aug 25, 2022

oh duh! Thanks so much!

Erik_Peterson · Aug 25, 2022

ok this awesome, but I’ve got something incorrect b/c I’m getting an error. I do see you were using a euro format date and I’m using a US based date format. Even when I swap the DD & MM in the formula it doesn’t seem to work. See attached screenshot....

Erik_Peterson · Sep 21, 2018

Thank you. I think I have those sorted out.

Erik_Peterson · Sep 20, 2018

Excellent! That is what I needed. However, it leads to another question. TONOW() shows the number of hours, but I really only need days. Anything less than 23.99hrs would be 0 days and so on. Do I need to wrap another function around the TONOW() in o...

User Statistics

User Activity

Pay schedule calculating dates

Counting days since previous date

Re: Pay schedule calculating dates

Re: Pay schedule calculating dates

Re: Counting days since previous date

Re: Counting days since previous date