Calcutlating a DueDate with a working days function

C

Chris

Hi,

I think I need a little help with my dates!

I have a field: [DateLoggedIn], which stores date entry date.

I am trying to achieve in a query is an expression which creates a new
calculated field as [DueDate}. This expression is to calculate 3 working days
from [DateLoggedIn}.

I have a function called “WorkingDaysâ€, which calculates the working days
and holidays, but I am having trouble applying it to the expression. I have
entered the following:

DueDate : DateAdd("d",3,(WorkingDays([DateLoggedIn])


Unfortunately it is not working, any help would be much appreciated!
Chris.
 
S

S.Clark

Further clarify 'not working'. Post error messages. Give an example input
and output. etc.
 
M

Michael Gramelspacher

Hi,

I think I need a little help with my dates!

I have a field: [DateLoggedIn], which stores date entry date.

I am trying to achieve in a query is an expression which creates a new
calculated field as [DueDate}. This expression is to calculate 3 working days
from [DateLoggedIn}.

I have a function called “WorkingDays”, which calculates the working days
and holidays, but I am having trouble applying it to the expression. I have
entered the following:

DueDate : DateAdd("d",3,(WorkingDays([DateLoggedIn])


Unfortunately it is not working, any help would be much appreciated!
Chris.

Normally there are two functions used with working days. One function
calculates the difference in working days between a supplied from_date
and a supplied to_date. This functions returns an integer value.

Another type of function adds to or substracts from a provided date a
desired number of working days. This function returns a date value.
This is what you are asking for, the date 3 days in the future from
DateLoggedIn.

Assuming you had such a function , it would be something like:

DueDate: WorkDaysOffset([DateLoggedIN],3)

see: http://www.mvps.org/access/datetime/date0012.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top