Please help:
Problem: Sort accounts into how many days between repodate and saledate.
Table Name: repotable
Fields: acctno, repodate, saledate, soldamt, saledate, soldyrmo
numdays = saledate - repodate
Example of my SQL (but it doesn't work in Fox Pro)
Select acctno, repodate, saledate, soldamt, saledate - repodate as numdays from repotable where soldyrmo = 200301 order numdays desc
The error must be the "saledate - repodate as numdays"
Result should be be:
acctno - repodate - saledate - soldamt - numdays
--- field explanation --
acctno = account number
repodate = Repossession date of item
saledate = sale date of repo item
soldyrmo = Sold in terms of year and month
numdays = number of days between repodate and saledate
----------------------------------------------------------------------------
Thanks for any help.
FoxPro 3 version user.
Problem: Sort accounts into how many days between repodate and saledate.
Table Name: repotable
Fields: acctno, repodate, saledate, soldamt, saledate, soldyrmo
numdays = saledate - repodate
Example of my SQL (but it doesn't work in Fox Pro)
Select acctno, repodate, saledate, soldamt, saledate - repodate as numdays from repotable where soldyrmo = 200301 order numdays desc
The error must be the "saledate - repodate as numdays"
Result should be be:
acctno - repodate - saledate - soldamt - numdays
--- field explanation --
acctno = account number
repodate = Repossession date of item
saledate = sale date of repo item
soldyrmo = Sold in terms of year and month
numdays = number of days between repodate and saledate
----------------------------------------------------------------------------
Thanks for any help.
FoxPro 3 version user.