Workday Application

[notrino]

Hello Friends,



I attched my application file. I need to see "end date" value , "it must be depends on days+holidays+weekends etc". Can you help me aboutthis topic? Thanks. (Like workday application in Excel)

[Perceptus]

there is nothing in this file you attached but the table. Double clicking on the Tablo1 table in the navigation pane shows you all the data including end date.

[notrino]

Hello,

In this table, "end date" area must be "calculating area" from "start date+days. "days" mean any number. For example, I have to work 75 days. Start date can be 18.02.2016, end date must be calculate from 18.02.2016+75 days. But result must be shift weekends +national holidays..weekends and national holiday values can be take from PC calendar or any Access table. How can I do this application?

[Perceptus]

After you have some data in your tables, you will need to make a query.

The functions you are describing are actually covered in access newer versions. Any Date can be converted to a number, the left hand portion of that number is the days, the right hand portion is the time. So CDate(#08/02/16#)+75 would give you 75 days next. There are even more functions to calculate work days. see below
https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

pretty much everything i could explain is on that link

[ssanfu]

Here are two sites with "workday" functions

http://access.mvps.org/access/datetime/date0006.htm (use 2nd function -> WorkingDays2)
https://msdn.microsoft.com/en-us/lib...ice.12%29.aspx

[notrino]

Hello Friends,

Thanks for your supports. But I didn't solve it, for my application. Please look at my attached file. Where is my mistake? I create Holiday table, I insert the code on my form etc.. But it is not working..

[ssanfu]

You need to fill out the Holiday table with your holiday dates.
I moved the function to a standard module.
I changed the form record source from a table to a query. The query is where the calculation is done.
The work days is not stored because it can be calculated at any time.

[notrino]

Hello ssanfu,

Thanks for your answere. But this application is not working. Did you try it? Is it working on your PC? Error description is : "syntax error in date in expression"

[ssanfu]

Yes it works for me.

What is your date format? (mm/dd/yyyy or dd/mm/yyyy)

See http://www.allenbrowne.com/ser-36.html