Microsoft Access Function - Date&Time

£10-20 GBP

Closed

Posted

over 6 years ago

£10-20 GBP

Paid on delivery

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

Project ID: 15925980

About the project

12 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

12 freelancers are bidding on average £19 GBP 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 Programming, Excel, Microsoft Access, SQL, Visual Basic

£27 GBP in 1 day

4.9

(326 reviews)

7.9

@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 depending on the 3 shifts you mention in your brief. In fact, I'll be able to deliver within an hour from awarding. I'm looking forward to hearing from you. Paris.

£20 GBP in 0 day

4.9

(261 reviews)

7.5

@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 (Date()+#15:00:00#) And (Date()+#23:00:00#) ?

£18 GBP in 1 day

4.9

(189 reviews)

6.9

@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 sure I am serious. Regards, Fabrice

£22 GBP in 1 day

4.7

(90 reviews)

7.3

@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 developer since 1997 and I can write for you a user-friendly program using MS Access . I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work. Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details. Thank You and Regards, Zura

£23 GBP in 1 day

4.6

(53 reviews)

6.2

@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

4.9

(36 reviews)

4.7

@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 solution was ok, other than the Odbc connection not working, making it more difficult!

£17 GBP in 1 day