Cross table Month filed columns to month conversion

[Hemanth458]

I had done cross table for Month columns into Month format by using Date(Date#(Left(Trim(Period),3),'MMM')) till here no issue for me but, When i have used Num() on top it then its given values as below:

Month	Num(Date(Date#(Left(Trim(Period),3),'MMM'))) O/p	Actual O/P
Jan	-363	1
Feb	-332	2
Mar	-304	3
Apr	-273	4
May	-243	5
Jun	-212	6
Jul	-182	7
Aug	-151	8
Sep	-120	9
Oct	-90	10
Nov	-59	11
Dec	-29	12

[sasiparupudi1]

if your period is in the format JAN2019

Month(Date#('Jan2019','MMMYYYY'))

 hth