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