Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a monthYear field coming from master calender as num.
Date(monthstart(TempDate), 'MMM-YYYY') AS MonthYear,
while as I used following expression in my Data source to generate monthYear field .
Month(date#(MTH,'MMM'))&'-'&YR as MonthYear, this one comes as text
I tried using num in my datasource expression but it converts it to num .
how can I make my second expression to match my master calendar type.
May be this:
Date(MonthStart(Date#(Month(date#(MTH,'MMM')) & '-' & YR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear
or this (simpler version of the above)
Date(MonthStart(Date#(MTH & '-' & YR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear
May be this:
Date(MonthStart(Date#(Month(date#(MTH,'MMM')) & '-' & YR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear
or this (simpler version of the above)
Date(MonthStart(Date#(MTH & '-' & YR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear
Thanks Sunny!!!