ContributionsMost RecentMost LikesSolutionsFill in date check box is checkedI would like a field to populate the date a box is checked.... How would I go about this? ------------------------------ Angela Bowman ------------------------------ Re: Number of daysI got it... never mind! thanks. ------------------------------ Angela Bowman ------------------------------ Re: Number of daysIf( not IsNull([Date completed]),"", ToDays([Estimated completion date]-Today())) ------------------------------ Angela Bowman ------------------------------ Number of daysI have two fields- estimated completion date and date completed. I am trying to create a formula to populate the number of days to complete the project ONLY if date completed is null. I can create the formula and make it work if I leave out the completed part, put am getting an error when trying to incorporate the completed field. ------------------------------ Angela Bowman ------------------------------ Weekly emailed report when a field is added or modifiedI have a table that contains 1000s of contacts. I am trying to create a weekly notification that is emailed to a user when a specific field (email address) is added or changed. I can create a notification for each record, but would rather it only be emailed weekly for those that have been added or changed. Any help is appreciated. Thank you. ------------------------------ Angela Angela ------------------------------ Re: Add Multiple Records to New Tableyes, that is the situation...Add Multiple Records to New TableWe have a list of contacts and every few years we need to review them for changes. There is a review table that we created that asks the reviewer a number of questions. In the original table, when the contact is set to be reviewed, there is a "Add Record" button that will add the contact to the review table. The issue is that our database has grown significantly and I now have over 200 "Add Record buttons. Is there a way to get all of the reviews initiated at once?Re: Formula - Date if a condition is trueIs there a way to format the original equation as a date field and instead of putting NA, it is just blank?Re: Formula - Date if a condition is trueI keep getting Type- Mismatch error... saying the Field is a text type and days(30) is duration. Probably because one of the due dates I'm using is the original date we calculated in the first place using a text formula?Re: Formula - Date if a condition is trueWorks Great. Thank you. I'm trying to flowing the same logic for another field, but thinking I have too many variables... I need a field to return one of two due dates if a specific field is not picked... The three fields are: Short or Long? - Multiple Choice Due date- date field Extension due date- Date field only if a box is checked. If Short is chosen, then return "NA". If long is chosen, then I need it to return a date 30 days after either the due date or extension due date if box is checked. Any Thoughts?