Emptying global field & finding data in date field

[Sanjai]

Hi Everyone,

I have a global date field on a layout. I want to empty everytime the user is navigated to the layout. I tried using

set field(gDateField,"")

Since I have assigned an empty string to a date field, it always shows "?" (Question Mark) instead of emptying the field.

My first question is how can we empty a global date or a date field?

My second question is how to find records in a file which contains data in one of the date fields?

To find out records which contain some data, we use "*" in find mode. If we use * in a date field in find mode, it does not allow.

Waiting for a solution.

Thanks,

--Sanjai

[Walter B]

First question: You are actually trying the set a null value with your script step, and that is not in a recognized date format. Try using the Clear step instead in your script to empty the field.

Second one, searching on dates can be a little tricky. When you set the search parameters it is actually looking for a date. What I normal do for this type of situation where I am looking field with dates in them is to do search where Date Field > 1/1/1900. If there is a blank date field it will be excluded from the find.

Hope this helps

[Sanjai]

Hi Walter,

Thanks for your solution. The clear field would be a good idea and also the date trick would solve my problem.

--Sanjai

[Vaughan]

To null a date field usign set Field, use TextToDate("")