VFP String Builder 1

[Mike555]

Hi. I'm trying to build a simple string in VFP, and I'm receiving the error "Operator/Operand type mismatch". Here's what I'm doing...

MSG = "Note: This item is deleted as of " + DATETIME() + "."

It's seems pretty simple, but I can't figure out what I'm doing wrong

Thanks.

 

[Stella740pl]

You are not convertind DateTime data type to string. Try to use TTOC(DATETIME())

 

[Mike555]

That's what I was missing...Thanks!

 

[Mike555]

Stella,

One more question if you don't mind...

Is there a way that TTOC can be formatted to display date only? I checked the MSDN article on this function, but found their description rather obscure.

Thanks again

 

[Mike Lewis]

Mike,

Use TTOD(DATETIME())

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[Stella740pl]

Yes, TTOD(), and in your case you should convert it, also, as it creates a Date type, not Character. You can do it like this:

DTOC(TTOD(DATETIME()))

 

[Stella740pl]

Or, if you don't need the time portion of DATETIME() at all, just use DTOC(DATE()) instead.

 

[Mike555]

Thanks!

 

[TamarGranor]

You can also use TRANSFORM() in this situation, so you don't have to think about what type you're starting with:

TRANSFORM(DATE())

Tamar