Microsoft Access Function - Date&Time

£10-20 GBP

Ditutup

Dibuat

lebih dari 6 tahun yang lalu

£10-20 GBP

Dibayar ketika dikirim

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 Proyek: 15925980

Tentang proyek

12 proposal

Proyek remot

Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

12 freelancer menawar dengan rata-rata £19 GBP untuk pekerjaan ini

@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 dalam 1 hari

4,9

(326 ulasan)

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 dalam 0 hari

4,9

(261 ulasan)

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 dalam 1 hari

4,9

(189 ulasan)

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 dalam 1 hari

4,7

(90 ulasan)

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 dalam 1 hari

4,6

(53 ulasan)

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 dalam 1 hari

4,9

(36 ulasan)

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 dalam 1 hari