Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all, need your help pliss..
i have a little problem here,
this is my load script,
load
NoRek as NoRek_CAD,
NoPin as NoPin_CAD,
min(date(CicilDate)) as MinCicilDate,
num(interval(today() - min(Date(CicilDate)))) as AgingDay,
from
this is my SQL Picture,
you can see from the script and picture above,
the result of MinCicilDate is 2009-08-05.
but what i want is 2010-05-05. because Paidstatus = 0, Which mean customer haven't paid in that period.
i must get min(cicildate) where paidstatus = 0 to calculate AgingDay.
note, cicildate same as duedate.
the problem is how to use WHERE is my script,
min(date(CicilDate)) where PaidSts = 0 As MinCicilDay,
because the real agingday is (today - MinCicilDay where PaidSts = 0)
What is the syntax of WHERE?
plis complete my syntax above .
plis help..
thank you very muchh..
regards !!
Hi,
after taking a quick look at your post...
is 'PaidSts' in your CorAccountDetail.qvd?
If so, you should be able to load with
===========================================
load
NoRek as NoRek_CAD,
NoPin as NoPin_CAD,
min(date(CicilDate)) as MinCicilDate,
num(interval(today() - min(Date(CicilDate)))) as AgingDay,
from
where PaidSts=0
group by NoRek, NoPin;
==============================================
Hope this helps. If not provide more information!
Regards
Martin
Hi,
after taking a quick look at your post...
is 'PaidSts' in your CorAccountDetail.qvd?
If so, you should be able to load with
===========================================
load
NoRek as NoRek_CAD,
NoPin as NoPin_CAD,
min(date(CicilDate)) as MinCicilDate,
num(interval(today() - min(Date(CicilDate)))) as AgingDay,
from
where PaidSts=0
group by NoRek, NoPin;
==============================================
Hope this helps. If not provide more information!
Regards
Martin
wow.. it's work martin
thank you so muchh
have a nice day,
regards!!