I hope this helps.
Calculate 1st date of month.
[Working day YM1]
date(str(year([Working day]))+","+str(month([Working day]))+",1")
Calculate the days of month with taking difference of 1st date of NEXT montn.
[Day in Month]
datediff('day',[Working day YM1],dateadd('month',1,[Working day YM1]))
Change the field to discrete.
workingday.twbx 22.0 KB
wow this rocks. It is perfectly working. Thanks a lot
You are very welcome!!
1 of 1 people found this helpful
Just adding this in for reference (assuming I am understanding the question)
DATEPART('day', DATEADD('day', -1, DATEADD('month', 1, DATETRUNC('month', [DATE]))))
1. Truncate to the Month Level (The 1st of the Month - June 1st)
2. Add a Month (Now it is July 1st)
3. Subtract a day (Now it is June 30th)
4. Get the Datepart of day (30)
Hope this helps!