How do I check if date field is blank.

Question

1.00/5 (1 vote)

See more:

Dear all,

I am new to programming, I am trying my first code (VB or c#) in creating below workflow.

I have a date field in my ERP and if its blank it should give an error message "Cannot be Blank", else allow the user to finalize the document.

Your help will be highly appreciated...

Thanking you
ROSS

What I have tried:

I am new to programming, just tried the code below:

if ["DELIVERY_DATE.NewValue"] = "00:00:00" then
msgbox "Please enter Delivery Date"
Else
msgbox "Queue In for Approval"
End if

Posted 7-May-18 20:58pm

Member 13816603

Updated 7-May-18 22:02pm

Add a Solution

Comments

Richard MacCutchan 8-May-18 3:16am

You have tagged this question C# and VB, so which is it? And what is DELIVERY_DATE.NewValue supposed to be, as it looks like a simple string from here?

Member 13816603 8-May-18 3:28am

code can be either in VB or C#.
DELIVERY_DATE is the field in schema.

Member 13816603 8-May-18 3:35am

Data type of Date is system.DateTime format for each user.

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)

OriginalGriff · Answer 1 · 2018-05-07T22:04:00

You have to remember that we can't see your screen, can't access your HDD, and can't read your mind - we only get exactly what you type to work from.
So we have no idea what is in your data - and it seems neither do you!

So start by finding out. Use the debugger to put a breakpoint on this line:

VB

if ["DELIVERY_DATE.NewValue"] = "00:00:00"

(Assuming it compiles, which I'm not convinced it will) and run your app. When the debugger hits the breakpoint, it will stop and let you take control of what is going on - including the ability to look at variable contents while you code is running.
Look at the field until you find a genuinely empty field (i.e. one in your data source that is empty), and it should show you what to test for.

We can't do that for you: we just don't have access to your data!