Closed

Microsoft Access Function - Date&Time

I would like a function created to store a shift time

Shifts are

Earlies - 07:00-15:00

Lates - 15:00 - 23:00

Nights 23:00-07:00

Based on the current system time i would like a function call Current shift to give me the output of in the region of e.g. 08:37 would give Between (Date()+#07:00:00#) And (Date()+#15:00:00#)

17:41 would give Between (Date()+#15:00:00#) And (Date()+#23:00:00#)

23:58 would give Between (Date()+#23:00:00#) And (Date()+1+#07:00:00#)

01:54 would give Between (Date()-1+#23:00:00#) And (Date()+#07:00:00#)

This function would then be used in Queries criterias

Skills: Database Programming, Excel, Microsoft Access, SQL, Visual Basic

See more: search function microsoft access coding, microsoft access find function, using search function microsoft access, microsoft access function, access query count time periods examples date, basic search function microsoft access, searh function microsoft access, microsoft access search function name, find function microsoft access, email function microsoft access, microsoft access email function, insert current date time mysql using perl cgi, microsoft access database search function, environment microsoft access function, email microsoft access function, system time microsoft access, microsoft access search function code, microsoft access search function

About the Employer:
( 1 review ) Le193ej, United Kingdom

Project ID: #15925980

14 freelancers are bidding on average £19 for this job

schoudhary1553

Greeting, I have understood your Microsoft Access Function - Date&Time task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database Progr More

£27 GBP in 1 day
(215 Reviews)
7.2
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. I will focus on user friendly interface. As you can see I have very good rate, you can be sur More

£22 GBP in 1 day
(85 Reviews)
7.3
paris2785

Hi, there. My name's Paris and I'm an experienced Access developer. I've completed a big number of complex databases and consider myself an expert in SQL queries. I can help you with your procedure to return records More

£20 GBP in 0 days
(160 Reviews)
6.8
customizedata

I have gone through the description, all is clear.. just wanted to ask question about the function output, will it be a string showing shift name E.g "Lates " in case of "17:41" as current time or string showing (D More

£18 GBP in 1 day
(146 Reviews)
6.5
zu02

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel de More

£23 GBP in 1 day
(43 Reviews)
6.0
crypthne

I have extensive knowledges in MS Access and Excel, especially in VBA. I've read and understand the description, I'm sure can work and finish this project as requested.

£18 GBP in 1 day
(33 Reviews)
4.7
Altantsetseg

Hello. I have been experienced in programming including MS Access since 2000. I had been working as a senior developer for the financial system developed in MS Access for over 6 [url removed, login to view] your project declaration, i More

£23 GBP in 1 day
(5 Reviews)
4.1
arranmercer

Hello, This is a VBA function which i can create for you, and then it is called like this: Myfunction(yourfield) Then the output will be earlies, mates etc. Relevant Skills and Experience Hopefully the previous VBA More

£17 GBP in 1 day
(6 Reviews)
3.6
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

£18 GBP in 1 day
(13 Reviews)
3.9
vw6767981vw

Hi there I'm [url removed, login to view] of InfoSec with good knowledge of excel and vba. I will hope can help you to do your job. Ready to begin.

£13 GBP in 1 day
(12 Reviews)
3.3
hsingla85

Available Immediately | MS Excel Expert | VBA Master | Assured timed delivery of the projects | Proven track record on upwork and freelancer

£18 GBP in 1 day
(2 Reviews)
1.9
£12 GBP in 1 day
(1 Review)
0.1
£13 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 1 day
(0 Reviews)
0.0