Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Timestamp issue in monthend function

Hi All,

I have date in timestamp format like "01/30/2018 10:56:01 AM". Now I want previous 2 months data.

I tried this,

Vmaxdate=date(peek(maxdate));

Vmonthstart=monthstart(maxdate,-2);

Vmonthend=monthend(maxdate,-1);

Issue is,

I am getting the date from Aug 1st to sep 29th but I need Aug 1st to sep 30th. Could you please let me know how to handle this kind of problem. I know that monthend falls into time 11:59.

1 Reply
Highlighted
MVP
MVP

please post a small sample app that demonstrates your issue.