Start function returning start of the week when I pass a Month period as a parameter

chilled0ut
Contributor

Start function returning start of the week when I pass a Month period as a parameter

When I apply the Start function below against a Month period it returns the week period start instead of the start of the month for the month period. The calendar setting has calendar type set as week which I guess is the reason it's returning the start of the week. Is there an easy way or another function to that will return the start of the month period? I can try doing the additional calculations to get the 1st of the month output but was hoping there's a one function call that will do this. 

 

chilled0ut_0-1645420675818.png

 

 

 

 

1 REPLY 1
chilled0ut
Contributor

Ignore ... just decided to use Date(year, month, 1) function for this