topic Increment date field in QlikView

Increment date field

Fri, 19 Jun 2009 20:57:19 GMT

Hi,

How can I increment the date field by 1? Assuming the best way to do this is a macro then how do i finish this sub...

sub inc()
set f = ActiveDocument.GetField ("Date")
f.select ???????
End sub

Increment date field

Fri, 19 Jun 2009 21:35:27 GMT

By increment the date, do you mean select tomorrow?

If so, you can use the VBScript function DateAdd: f.select DateAdd("d", 1, Day())

I tried to test it out and my fields have timestamps, which didn't want to cooperate. This should work fine if your values are dates only.

Increment date field

Sat, 20 Jun 2009 00:32:01 GMT

No i mean more broadly increment by n days.

Using your code I get an error on the

select DateAdd("d", 1, Day())

Wrong number of arguments or invalid property assignment: 'Day'

Thanks

Increment date field

rwunderlich — Sat, 20 Jun 2009 00:36:46 GMT


Alkaline wrote:i mean more broadly increment by n days

A date is stored as number of days since the epoch date. To increment by n days, add n.

-Rob

Increment date field

Sat, 20 Jun 2009 00:47:42 GMT

Yes which is what (in principle) that code does.

But to clarify, the code doesn't work and I'm not sure why:

sub inc()
set f = ActiveDocument.GetField ("Date")
f.select DateAdd("d", 1, Day())
End sub

i tried this instead

f.select DateAdd("d", 1, Day(myselection.Item(0).text))

That compiles, but it doesn't change the date

Increment date field

Sat, 20 Jun 2009 01:25:16 GMT

I'm sorry, the VB Script function is Date() not Day().

As Rob said, you probably don't need to bother with DateAdd (old habit). Just add, so: f.Select Date() + n.

Increment date field

rwunderlich — Sat, 20 Jun 2009 01:28:25 GMT

I wouldn't mess with VB functions. Easier to use QV functions with Evaluate().


'Select today.
 ActiveDocument.GetField("Date").Select ActiveDocument.Evaluate("today(1)")

'Select tomorrow
 ActiveDocument.GetField("Date").Select ActiveDocument.Evaluate("date(today(1)+1)")

'Select 5 days from current selection.
 ActiveDocument.GetField("Date").Select ActiveDocument.Evaluate("date(only(Date)+5)")

-Rob

Increment date field

Anonymous — Mon, 05 Jul 2010 21:59:56 GMT

Hi,

I have a problem similar to this, but couldn't solve it with your tips (yet).

Could you have a look?

http://community.qlik.com/forums/t/31069.aspx

Thanks,