Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Always want to show only last 12 months based on below expression in list box:
=Month ([GSE by KT plant.Month]) & '-' & Year ([GSE by KT plant.Month])
Please suggest ???
Thanks,
AS
Aggr(if([GSE by KT plant.Month]>='$(=Max([GSE by KT plant.Month],10))', [GSE by KT plant.Month]),[GSE by KT plant.Month])
why you are doing this: =Month ([GSE by KT plant.Month]) & '-' & Year ([GSE by KT plant.Month])??
Instead of this use monthname(DateField) at script, you will get same result....
see this:
Why do you not use MonthYear() function?
To get Month and Year from [GSE by KT plant.Month]
Actually we are not having any date field for this application
Thanks,
AS
what is values in [GSE by KT plant.Month] field?
Thanks,
AS
Use Makedate or monthname function if you have only Year or month field like
=MonthName(MakeDate(Year([GSE by KT plant.Month]),Month([GSE by KT plant.Month])))
And try
=Monthname( Addmonths(MonthName(MakeDate(Year([GSE by KT plant.Month]),Month([GSE by KT plant.Month]))),-12))
Regards
Anand
Hi Anand,
=Monthname( Addmonths(MonthName(MakeDate(Year([GSE by KT plant.Month]),Month([GSE by KT plant.Month]))),-12))
This one is not working!
Thanks,
AS
Just want to show Nov 2014 till Oct 2015 inside list box from the above example.
Thanks
AS