SET DATE TO BLANK 3

[randallJ]

Hi

This is probably really easy but can't seem to get my head around it.

How do you clear a date field. E.g a date field has an existing date in it and I want to remove that date and make the field blank.

 

[Mike Lewis]

How about:

REPLACE DATE WITH {}

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Mike Lewis]

When I said:

REPLACE DATE WITH {}

I really meant:

REPLACE MyDateField WITH {}

Another possibility:

BLANK FIELDS MyDateField

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Mike Gagnon]

Aside from Mike's suggestions, another on might be.

REPLACE MyDateField WITH CTOD("")

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[randallJ]

Thanks all - I had tried various combinations of ctod() but always got the "argument mismatch" error.

 

[ramani]

Hi

Sorry to doubt the fundamentals..

When you say field, every one here assumed it is a field in your table or database. By any chance do you mean that the variable which holds a data field (a field of a table).

If it is variable, you can try..
myDateVariable = CTOD("")
or
myDateVariable = {}
or
myDateVariable = {//::}

try it.



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[NasibKalsi]

Randall:

You have all the possible solutions listed above. You might consider this.

If it is not a conditional BLANK out then you can try

alter table ToughTable alter column DATEFIELD c(8)
replace all DATEFIELD with ' '

* if you need back to date type.
alter table ToughTable alter column DATEFIELD d

I hope this will help.


try it.

Nasib Kalsi

 

[tsh73]

ok, if you have "argument mismatch" error
- now it's time to make sure you have indeed date field...
Check first this:
a={}
?type("a")
-- types D
a={/:}
?type("a")
-- types T
Now, what type is your field?
?type("your.field")
???