How to create a field in Calendar with the 15 th and last day of month?

[#1]

Hello,

how to create a field in the master calendar that contain the 15:th and last day of month? I need this

to be able to use it in Set Analyse with a counter or variable.

Håkan

[sbaldwin · Accepted solution]

Hi, try adding a field for your date field (called DateField) like

if(day(DateField)=15 or DateField = daystart(monthend(DateField)), 'Y','N') as Flag

Thanks

Steve