Get Previous Month from Today's date

[kushalthakral]

Dear All

How i can get Previous month from Current date as i need to generate QVD and use Month and Year as their filed using system date.

Thanks

Kushal Thakral

[SunilChauhan]

see the attched file

hope this helps

[preminqlik]

NEWTABLE:

Load *,

Month(AddMonths(Today(),-1))               as               PreviousMonth,

Year(AddMonths(Today(),-1))               as                    PreviousYear

resident Orginal;

store NEWTABLE into path\NEWTABLE.QVD;

[kushalthakral]

Thank You ALL

Regards

Kushal Thakral

[richard_pearce6]

Here's a calendar which allows you to determine previous periods depending on dates using flags

http://community.qlik.com/docs/DOC-6593

Regards

Richard

QlikCentral.Com