Null Date Value

[lashwarj]

I list box the uses add values to, they add a char value and a date value, but i need to make it so they can insert a blank date value.

With a text box you can simply do = ' '
Is there a method you can use to do the same for dates

 

[fluteplr]

Do you want a null date or a blank date? They are not the same.

You can do a blank data by the following

replace mydatefield with {}

a null date by

replace mydatefield with null

 

[lashwarj]

These values are being inserted into a list box, when i try

REPLACE Thisform.refer_Date.value WITH {}

I get a syntex error

 

[lashwarj]

IF i use the NUll, it gives a not a charater expression due to it being a date value I believe

 

[lashwarj]

One more,


'Value' is not a file variable


REFERAL_TYPE = ALLTRIM(This.Value)
REPLACE Thisform.Refer_Date.Value WITH {}
REFER_DATE = (Thisform.Refer_Date.Value)


is the code

 

[jimstarr]

REPLACE Thisform.refer_Date WITH {}

Jim

 

[AirCon]

lashwarj

REPLACE Thisform.Refer_Date.Value WITH {}

I'm a bit confuse here. As far as I know, you can't do a "replace" into "object.Value". You can only replace into the field directly or use macro


-- AirCon --