Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

venkateshraj
New 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
MVP
MVP

Re: Timestamp issue in monthend function

please post a small sample app that demonstrates your issue.