Save DATE Format Value into a TEXT Field ???

[kev100]

I'm feeling kinda silly here....this can't be difficult.

I've been searching this forum and haven't been able to find a solution.

I need to store an existing value which is in the DATE format to a character (text) field.

I thought STR was it (e.g. TextValue = STR(DateValue)

But that causes an error.

Is the syntax incorrect on the STR function? Other?

Thanks very much.

 

[mm0000]

You can either use :

replace fieldname with transform(Datefield)

or

replace fieldname with dtoc(Datefield)

 

[kev100]

Thanks very much...

TextField = Transform(DateField)

...works great.

 

[Imaginecorp]

In addition to mm0000 suggestion,
If you plan to index on that field, it would be efficient to convert to a string:
? DTOS(date())
**20070203
Also easier to compare, and or seek()

The only hassel here is to re-convert it back to a date()
cToday = DTOS(Date())
dToday = DATE(VAL(LEFT(cToday,4)),;
VAL(SUBSTR(cToday,5,2)),;
VAL(RIGHT(cToday,2)))

 

[Mike Lewis]

Also, keep in mind that if you use either TRANSFORM() or DTOC(), the result will vary according to the current settings of SET DATE, SET CENTURY, etc.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

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