I need to print the number of days between tfacp200.docd and the current date in a simple sql. Example:
select
tfacp200.suno, tfacp20.ninv, tfacp200.docd, tfacp200.amth
fron
tfacp200

BaaN-IVc3
How can the current date be selected?
Any help appreciated.

I need to print the number of days between tfacp200.docd and the current date in a simple sql. Example:
select
tfacp200.suno, tfacp20.ninv, tfacp200.docd, tfacp200.amth
fron
tfacp200

BaaN-IVc3
How can the current date be selected?
Any help appreciated.

Hello,

date.num()

I think what bdittmar was saying is you could do something like this:


domain tcdate today
long days.diff

today = date.num()
select tfacp200.suno, tfacp20.ninv, tfacp200.docd, tfacp200.amth
from tfacp200
where ....
selectdo
days.diff = today - tfacp200.docd
endselect


And if the days.diff needs to be printed you could make it external for a report. Or you could pass tfacp200.docd and today to the report and then just print tfacp200.docd - today.

Mark