[Issue Update ID],
[Issue Update Comment],
[Date of Update],
[Date of Update]&'_'&Project as _key
(ooxml, embedded labels, table is Feuil1);
Load Project as ID,
max(date([Date of Update],'DD/MM/YYYY')) as maxdate
group by Project;
Thanks for the answer ...
I am trying to find a month before my maxdate.
Trying to use the following expression-
max(date(addmonths(Max(Date#(reportdate,'DD-MMM-YYYY')),-1),'DD-MMM-YYYY')) as maxdate,
But unable to ..
Appreciate your help in this.
let's assume ur have this table:
loac a,b,c, date from source;
create ur monthdate field :
loac a,b,c, date , Month(date)&' '&year(date) as MonthYear from source;
//now load this new MonthYear field in a resident table:
load distinct MonthYear resident table order by MonthYear ascend;
//now, let's see how many rows there is in this table:
// and now let's peek the previous to last month (=the previous to last row)
and there u have it
Hope this helps
I have this reportdate column in my base
if("Month"='Oct' and "Fiscal Year"='2017','31-Oct-2017', if("Month"='Sep' and "Fiscal Year"='2017','30-Sep-2017',if("Month"='Mar' and "Fiscal Year"='2016','31-Mar-2017',if("Month"='Aug' and "Fiscal Year"='2017','31-Aug-2017', if("Month"='Nov' and "Fiscal Year"='2017','30-Nov-2017' ,if("Month"='Dec' and "Fiscal Year"='2017','31-Dec-2017',if("Month"='Jan' and "Fiscal Year"='2017','31-Jan-2018'))))))) as reportdate
The most recent reportdate i.e.- 31-Jan-2018
I want an expression which can return a month prior to the most recent date i.e. -31-Dec-2017