Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set calendar date as current months first date

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

1 Solution

Accepted Solutions
Not applicable
Author

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,

DJ

View solution in original post

3 Replies
Not applicable
Author

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,

DJ

Not applicable
Author

thanks buddy

Not applicable
Author

apply

v.SetContent monthstart(today()),true