topic Re: Current Month Jan to Previous Month Dec in App Development

Current Month Jan to Previous Month Dec

aswinnar — Sat, 16 Nov 2024 01:27:35 GMT

Hi All,

I am having a requirement where I need to place values for current month vs previous month

FIELD1	Date (Year month format)
A	202009
B	202010

C	202011
D	202012
E	202101

I have variable set for value in current month, however I am not able to create a proper expression for getting the values from the pervious Year Month. Mainly because of Jan to Dec. If I use 202101 as current Year Month for example, I am getting 202100 as Previous Year Month Date. What expression can I use for when current year month is 202101, the previous year month date will show as 202012?

Re: Current Month Jan to Previous Month Dec

Vegar — Tue, 15 Sep 2020 21:14:28 GMT

By the looks of it your date field is not a date, but an integer. Therfore you can not use date funtions like addmonth() on it without manipulating it a bit. Try something like this to get prev month.

Num(Text(Date(Addmonths(date#([Date Field], 'YYYYMM'), - 1), 'YYYYMM')))

Re: Current Month Jan to Previous Month Dec

bhavyagrb — Mon, 21 Sep 2020 13:35:34 GMT

Hello,

Hope this helps you!!

In Frontend Expression:

=date(Addmonths(date#([Date(Year month format)], 'YYYYMM'), - 1),'YYYYMM')

Regards,

Bhavya