Date Help

[arusanah]

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.

[sunny_talwar · Accepted solution]

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

[arusanah]

Thanks Sunny!!!