month

[raadwiptec]

I need data for Previous month plus current month until today?  any suggestion

[Chanty4u]

chk dis

Set Analysis Current Month vs Previous Month

The Above Function

[sunny_talwar]

May be something like this in your set analysis:

{<DateField = {"$(='>=' & Date(MonthStart(Today(), -1), 'YourDateFieldFormat') & '<=' & Date(Today(), 'YourDateFieldFormat'))"}>}

[raadwiptec]

hi sunny

I need it over a button not on the chart..

I created 2 variables current and previous month but its not working.

[sunny_talwar]

Would you be able to share what you have thus far?

[raadwiptec]

hi sunny,

its a big report.. iam just adding this addition button as adhoc for users. I created 2 variables

=Month(AddMonths(date(Today()),-1)) - Previuos month

=Month(Today()) as Current Month

Both works. in button individually . But I need the report display as until today and February..

[sunny_talwar]

Are these buttons making selection? Are you looking for a button which selects Previous month till today?

[sunny_talwar]

Something like this?

[raadwiptec]

yes something like that

[raadwiptec]

can u tell me what you have used to combine these 2