Date field issue wherein I need to select previous month.

[#1]

Hi Everyone,

I have a field YearMonth which has values like 201507, 201506, 201505 ..201501.

I want to create an other field like PreviousYearMonth which should display 201506,201505,201504....201412 .ie previous month data for YearMomth.

I am facing issue to handle January month . Like if I select January , for eg 201501. It should give 201412.

Kindly help me with this issue.

Thanks in advance..

[Clever_Anjos]

=date(addmonths(Date#('201501','YYYYMM'),-1),'YYYYMM')

[jonathandienst]

For this sort of analysis, I create a MonthIndex field in my master calendar:

     Year * 12 + Month As MonthIndex,

Now for the set analysis:

     =Sum({<MonthIndex = {"$(=Max(MonthIndex) - 1)"}>} Sales)

But you will probably be making selections on fields Year, Month. You will need to ignore these selections:

     =Sum({<MonthIndex = {"$(=Max(MonthIndex) - 1)"}, Year=, Month=>} Sales)

[#4]

Thanks Clever Anjos and Jonathan Dienst .

I will try above solutions provided by you and gert back on this.

[sujeetsingh]

Format the dates as per your need and use inter-record function previous()

[#6]

Hello Clever

This seems to be particularly for the month of Jan, I need a generic expression which will take care for all other months including January.

However i will try to work on above expression.

[#7 · Accepted solution]

Hello Clever

It is working fine..!! Thanks

[Clever_Anjos]

Instead 201501 could be any month, it was just an example

=date(addmonths(Date#('201501','YYYYMM'),-1),'YYYYMM')

[#9]

Exactly!!

[#10]

Hello Chintan,

Hope this will help you out.

Main:

Load *,Date(AddMonths(Date#(Dates,'YYYYMM'),-1),'YYYYMM');

load * Inline [

Dates

201507,

201506,

201505

];

Thank you