Microsoft Access Function - Date&Time

£10-20 GBP

Zaprt

Objavljeno

pred več kot 6 leti

£10-20 GBP

Plačilo ob dostavi

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

ID projekta: 15925980

Več o projektu

12 ponudb

Projekt na daljavo

Aktivno pred 6 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

12 freelancerjev je oddalo ponudbo s povprečno vrednostjo £19 GBP za to delo

@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 v 1 dnevu

4,9

(326 ocen)

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 v 0 dnevu

4,9

(261 ocen)

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 v 1 dnevu

4,9

(189 ocen)

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 v 1 dnevu

4,7

(90 ocen)

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 v 1 dnevu

4,6

(53 ocen)

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 v 1 dnevu

4,9

(36 ocen)

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 v 1 dnevu