Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
udaya_kumar
Valued Contributor

how to get previous month date from a field in edit script?

Hi,

I am getting data from database and storing it in QVD.

I want to get latest date -1 (previous month date) from a field in the edit script.

how i can get it?

Tags (2)
2 Replies
Highlighted
rajeshvaswani77
Valued Contributor III

Re: how to get previous month date from a field in edit script?

Use addmonths(DateField,-1)

Highlighted

Re: how to get previous month date from a field in edit script?

Hi

Try like this

addmonths(DateField,-1) to get the previous month