Recent content by qster

Hi, Does any have or know the code to pull information (dates) from a textbox into another textbox for formatting. What I want to do is take startDate and add 30 Days to that date once I hit a button to calculate the 30 days beyond a date. Thank you.

Hello, I am trying to create a form in Access to calculate future dates. What I am trying to accomplish is setting a due date. i.e. 30 days, 60 days and 90 days. This works fine with the simple formula, however I would like to add some special conditions. For example: 1. I've figured how to...

I have a problem regarding excluding certain dates from calculating future dates. Say I can't use specific months. (i.e. Winter months) and I want to be able to calculate a year from a date, but it doesn't include Dec., Jan. and Feb. So a year from a date (say Sep. 1, 2006) futuring dating it...

Thank you again. Here is another one.. Say I can't use specific months. (i.e. Winter months) and I want to be able to calculate a year from a date, but it doesn't include Dec., Jan. and Feb. So a year from a date (say Sep. 1, 2006) futuring dating it for a year should return Mar. 1, 2008 as it...

Pwise, Thanks for noticing the quotes. I have removed them and the query works now. However for some strange reason it doesn't show the dates unless I go to Form Desisn and back to Form view. Odd. Also... how would I change the query to use a 1 year range instead of a 30 day? Thanks in advance

CautionMP, This formula works great. Question, would I use the same formula or something close to it if I want to expand the criteria to be a year instead of 30 days? Keep in mind of any leap years with 366 days instead of the normal 365.

Yes, this is a form. I tried and created a table named "Tbl_Digits" Added a Field Named "DigitID" and put type as a "Number" and set as a primary key. then I added 1, 2 and 3 in the table. Created a new SQL query: SELECT Min(forms!"FutureDates"![StartDate]+30+[DigitID]) AS FirstWeekDay FROM...

It works with either "d" (day) or "w" (weekday) right now. "ww" is week

I have it on a MS Access Form right now. There is no Table data or queries. Would I have to import data into tables?

I put in the basic: =DateAdd("w",30,[StartDate]) where StartDate is date that is inputted to future date 30 days. Now.. where would I place this code? As an Expression or Code in MS Access?

Does anyone know the formula or Date function to use at future date 30 days? The key here is that the last date or day 31 must be a weekday and not a weekend date. i.e. The start date can be anydate, but after 30 days, the next date showing must be a weekday.

So you want to add a year (365 days) PLUS the number of days between the specified date range (89 days in this case)? I wanted to add 270 days (future dated) from the time of the StartDate, but to not count the days in between Dec. 1 to Mar. 31 of any year. So if the Start date is July 1, then...

I need a formula that will exclude all dates from Dec. 1 to Mar. 31 regardless of any year for the date calcuation. So if I have a StartDate of Jan. 14 200X, the future date of say 90 days forward should be June 29, 200x (30 in April + 31 in May + 29 in June = 90 days) The Datediff only works...

Will these dates apply to on-going years or would I need to restate the dates? Thank you

Hello, I created a form to calculate future dates based on an initial date entered into a form box. Where I am stumbling is setting an IF statement where I want to calculate 1 year future dated, but exclude a certain date range. i.e. Start date = July 1, 2006 and I want to future date for a...