"Append For" function does not work

[bebbo]

Postr is a table with a date field called date. It also has a numeric field called posid. If I use the following code notting is appended:

append from postr for date = ctod("20/12/2002&quot

However if I use the code below data is appended. Can I not use the code with a date field.

append from postr for posid = 1

I trying to do the following:

append from postr for posid = nTMP and date < ctod(dDATE)

 

[bebbo]

Sorry it not append for it append from .... For .....

 

[DSummZZZ]

What is your date setting? Make sure that when you use CTOD() it translates to what you are expecting, that it is the same format as what you are comparing with. If I do:

?ctod(&quot;20/12/2002&quot

I get ' / / '


Dave S.

 

[ramani]

Hi

APPEND FROM postr FOR DTOS(date) = &quot;20021220&quot;

** &quot;YYYYMMDD&quot; within quotes

SelectDate = date()

APPEND FROM postr FOR DTOS(FieldDate) = DTOS(DATE())


ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[KenMurphy]

Try using the date function: DATE(YYYY,MM,DD)

 

[baltman]

append from postr for date = {20/12/2002}

or as I would use it:
append from postr for date = {12/20/2002}

squiggly brackets denote dates... does anyone know what they are really called?

Brian

 

[craigsboyd]

Baltman,

{} <--CURLY BRACES


bebbo,

append from postr for date = {^2002/12/20}

...this adheres to the strict date format in VFP Slighthaze = NULL