Attached is the script where I am facing problem. I am just using a column "Service Date ", to find out the months and further calculating employees based on that. But when i wrote the followin script in load , its not working:
month(date#([Service Date],'MM/DD/YYYY')) as Cal_month
I think it should display month and should work properly.