Hello all, What is Syntax of DATEDIFF?

[#1]

Hellow Qlikviewers, i'm newbie, plis help

this is my syntax in SQL,

WHERE coraccount.closetype = 0 AND coraccountdetail.paidsts = 1 AND datediff(d,coraccountdetail.cicildate,coraccountdetail.paiddate) <= 150

what is syntax of DATEDIFF / Between??

thanks 😄

God bless

[#2]

i type like this

Count ({<CloseType_CA={0}, PaidSts_CAD={1}, interval(CicilDate_CAD - PaidDate_CAD) <= 150 >}Angsuran_CAD

also wrong,

note,

closetype_CA as coraccount.closetype

paidsts_CAD as coraccountdetail.paidsts

cicildate_cad as coraccountdetail.cicildate

paiddate_cad as coraccountdetail.paiddate

[shumailh · Accepted solution]

See this:

http://community.qlik.com/message/56620

Shumail

[#4]

first you copy this script in

function datediff2(d1,d2)
datediff2=datediff("D",d1,d2)
end function

in micro editor then after you call this macro in in your edit script editor

datediff2(Date1,Date2) as [No of day],

Regards

Ashish Srivastava