topic DATEADD(m, -1,getdate()) in Qlikview in QlikView

DATEADD(m, -1,getdate()) in Qlikview

Tue, 26 Jul 2011 13:43:39 GMT

Can't seem to find the anser to this...

Any one know the QV syntax for Sql Server's DATEADD(m, -1,getdate())... ie today's date minus one month???

Thanks, Mike

DATEADD(m, -1,getdate()) in Qlikview

Tue, 26 Jul 2011 13:56:55 GMT

Try this Addmonths(Date,-1)

-Sridhar

DATEADD(m, -1,getdate()) in Qlikview

Tue, 26 Jul 2011 14:51:05 GMT

Thanks Sridhar...

By the way... how did you know that??? I couldn't find anything online / in the reference pdf / in the community...

This community is great but I'm desperate for a decent QV Bible to be published!

Cheers again... Mike

DATEADD(m, -1,getdate()) in Qlikview

Tue, 26 Jul 2011 15:02:25 GMT

Mike, You could get this in this forum itslef. This has been discussed many times in this forum and other sources would be reference manual and Qlikview Help. Below is the content copied from Qlikview Help.

AddMonths(startdate, n , [ , mode] )
Returns the date occurring n months after startdate or, if n is negative, the date occurring n months before startdate.
By specifying a mode (0 if omitted) the date is set to either the unmodified day of the specified month (mode=0) or the calculated day as derived from the end of the month (mode=1).
Examples:
addmonths ('2003-01-29',3) returns '2003-04-29'
addmonths ('2003-01-29',3,0) returns '2003-04-29'
addmonths ('2003-01-29',3,1) returns '2003-04-28'
addmonths ('2003-01-29',1,0) returns '2003-02-28'
addmonths ('2003-01-29',1,1) returns '2003-02-26'
addmonths ('2003-02-28',1,0) returns '2003-03-28'
addmonths ('2003-02-28',1,1) returns '2003-03-31'

DATEADD(m, -1,getdate()) in Qlikview

Tue, 26 Jul 2011 15:05:51 GMT

Great - It never even crossed my mind to look in help when I need help... nice one thanks...