Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
rajeshvaswani77
Valued Contributor III

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

Use addmonths(DateField,-1)

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

Community Browser