Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)).