topic How will you calculate Date range from start date to end date in QlikView

How will you calculate Date range from start date to end date

Tue, 06 Apr 2010 08:51:13 GMT

How will you calculate Date range from start date to end date

set sd=ActiveDocument.Variables("sd")
msgbox("StartDate"&sd.GetContent.String)

set ed=ActiveDocument.Variables("ed")
msgbox("EndDate"&ed.GetContent.String)

edate=CDate(ed.GetContent.String)
sdate=CDate(sd.GetContent.String)

set endate=CDate(edate-sdate)

for i=0 to endate.count -1

msgbox("New Date:"&endate.item(i).text)

Tue, 06 Apr 2010 09:09:38 GMT

using this i got .....

first find the date differnce... from that we calculate remaining easily...

sub ed_final

set sd=ActiveDocument.Variables("sd")

'msgbox("StartDate"&sd.GetContent.String)

set ed=ActiveDocument.Variables("ed")

'msgbox("EndDate"&ed.GetContent.String)

edate=CDate(ed.GetContent.String)

sdate=CDate(sd.GetContent.String)

endate=DateDiff("d",sdate,edate)

'msgbox(endate)

ActiveDocument.Fields("ncolum").select sdate+1

for i=2 to endate

ActiveDocument.Fields("ncolum").ToggleSelect sdate+i

end sub

Tue, 27 Jul 2010 05:50:45 GMT

I am not too sure whether it helps you or not. But it is related to date range only. You can look into it!