Search:

Type: Posts; User: 12Strings; Keyword(s):

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    17,037

    Hi, I have checked the validity of the table and...

    Hi, I have checked the validity of the table and in
    all 3 records "recur" ='Y', "payrec" ='p', values are in "duedate",
    "datepaid" (type is DATE) and "periodic". I'm looping thru the data;...
  2. Replies
    1
    Views
    17,037

    need help w/date compare

    Hi, I just want to update a database
    table column (datepaid-type is DATE(YYYY-MM-DD) to the current date
    IF the duedate >= the current date, payrec = 'P', status = 'Y'and datepaid is ' '. I...
Results 1 to 2 of 2