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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add months function gives error

Hi,

     I am trying to find number of days in a month by using attached file but it is giving script error see the attachment for screen shot. Can some one help me to fix this issue?.

Thanks

Dasu.G

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Using the variables inside single quotes should resolve the script line error, like

date#( '$(vStartDate)' )

should resolve the error (so the first argument to date#() will be interpreted as string).

But please have a look also to my suggested alternate solution using day(monthend(DATE)).

View solution in original post

1 Reply
swuehl
MVP
MVP

Using the variables inside single quotes should resolve the script line error, like

date#( '$(vStartDate)' )

should resolve the error (so the first argument to date#() will be interpreted as string).

But please have a look also to my suggested alternate solution using day(monthend(DATE)).