Could it be that the value of those fields are actually set to character?
You could initialise each textbox with a value of ={} to ensure it's an
empty date
Frank.
Frank Cazabon
On 05/03/2013 11:38 AM, Kurt wrote:
I'm working on this other system of ours, where my boss complained of a
problem. I fixed one problem - but, then another problem occurred -
regarding an EMPTY() Test.
So - there's this form - to Enter Criteria for a Report. Its got numerous
date fields, each are in pairs (for a Range). So - I enter dates into a pair
of fields, and after I enter in the 2nd date field, the focus then jumps to
another date field. But, I don't enter in a Date there - and, instead - hit
the button to process the report.
As such, for that next pair of date fields - even though NOTHING is entered
on the screen for those fields, even though the cursor went into the 1st
date field - VFP reports the contents of those 2 fields as " / / " and
"". The field that has the slashes - looks to me like a Standard Empty Date
type of data. But, VFP reports back as NOT EMPTY when I use the EMPTY()
function on the Value of that field on the screen.
I find this to be Strange - since, it seems to me - that it SHOULD report it
back as EMPTY!
FYI - am using VFP7. Also, the Format property of that Text field is set to
"d", and there is No InputMask set. Again - these are settings on this Form
before I even touched it.
TIA,
-K-
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
