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: ms access vba functions, ms access date functions in query, microsoft access functions list pdf, access query functions, ms access functions examples, access date functions examples, ms access date format, microsoft access functions and expressions, 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

About the Employer:
( 2 reviews ) Le193ej, United Kingdom

Project ID: #15925980

13 freelancers are bidding on average £19 for this job


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
(226 Reviews)

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
(88 Reviews)

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
(168 Reviews)

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
(151 Reviews)

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
(47 Reviews)

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)

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
(21 Reviews)

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
(9 Reviews)

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 [login to view URL] your project declaration, i More

£23 GBP in 1 day
(6 Reviews)

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
(4 Reviews)
£12 GBP in 1 day
(3 Reviews)
£13 GBP in 1 day
(1 Review)
£18 GBP in 1 day
(0 Reviews)