Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
am showing a current view(monyear) data, bt now i need to show the trend two year's data bt it shud be dynamic, it shud pickup by default. How to do that.
so when am doing month(yearmonthfield) am getting the output as character means like dec
when am doing date((yearmonthfield),'yyyy/mm/dd' so am getting the output for month as 00
how to correct this date format
I need to substring that and pickup the month values
(201602)
so it shud pick 02
how?
its bit urgent ,kindly help
try like this
=Date(AddMonths(Today(),-12),'YYYYMM')
Where Month_Year =>Date(AddMonths(Today(),-12),'YYYYMM') and Month_Year <=Date(Today(),'YYYYMM');
I pulled out year and month two separate fields from my yearmonth,
now how to apply this addmonths condition,will it wrk the same way
no it won't ...follow the approach which I suggested
Which is the month year date format in your original table?
According to your business requirement, you should filter out data older than the previous 12 months. So the where clause should be there.
There must be a problem within your Date format. Please, provide more info on the MonthYear dimension so we can help you out
