how to calculate time from midnight to midnight for user data entry permission

Question

2.60/5 (2 votes)

See more:

VB

hi guys,

can anyone help me on how to allow user can do data entry only from 12:01 AM to 11:59 PM..

thanks,
musiw.

Posted 22-Oct-13 1:07am

musiw

Add a Solution

Comments

ZurdoDev 22-Oct-13 7:39am

Sure. Let them run the app.

ZurdoDev 22-Oct-13 7:40am

This does not make any sense unless I am dyslexic. You want to allow the user to run only from 12:01 AM to 11:59 PM. So, you are saying there is only 1 second in the day where they can't run it?

Pheonyx 22-Oct-13 8:22am

I think he is trying to exclude ~2 minutes in every day for some reason, I.e. 11:59.01 -> 12:01.00

ZurdoDev 22-Oct-13 8:27am

Ah, you're right. Still weird though.

Pheonyx 22-Oct-13 8:30am

Agreed, The only reason I can see for wanting to achieve this is if there is some major processing going on during those two minutes on the database server?

ZurdoDev 22-Oct-13 8:35am

True. But the question seems so trivial that there must be more to it.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pheonyx · Answer 1 · 2013-10-22T02:25:00

Solution 1

Sure,

In pseudo code you do this:

StartDate = New Date (Todays Date, 00:01)
EndDate = New Date (Todays Date, 23:59)

If DateTime.Now is not between StartDate and EndDate then Disable Data Entry

Posted 22-Oct-13 2:25am

Pheonyx

v2