topic How to set calendar date as current months first date in QlikView

How to set calendar date as current months first date

Tue, 17 Jan 2012 08:54:47 GMT

Dear All,

I have to calendar objects by which managing start date and end date .

everything is working fine.

Requirment is whenever a user presses on clear button , these two calendar objects should show

first object : 1st date of the current month

2nd object : current date

I have implemented end objects through macro

2nd object :

set v = ActiveDocument.Variables("To Date")

v.SetContent Now(),true

Please let me know , how to set first calendar object.

Regards

Pramo0d Kumar

Tue, 17 Jan 2012 09:06:43 GMT

Hi,

You can use below code to get first date or current month.

set v = ActiveDocument.Variables("vFromDate")

v.SetContent dateserial(Year(Now()), Month(Now()), 1),true

Cheers,

Tue, 17 Jan 2012 09:22:28 GMT

thanks buddy

Tue, 17 Jan 2012 09:24:00 GMT

apply

v.SetContent monthstart(today()),true