I need a formula for a certain time of the month to equal yes or no.
I need a formula stating if date created occurred between the 1st and the 14th, yes is the value in the field.
Forum Discussion
Try this
var number DayNumber = Day(ToDate([Date Created]));
IF($DayNumber >=1 and $DayNumber <= 14,"yes")
var number DayNumber = Day(ToDate([Date Created]));
IF($DayNumber >=1 and $DayNumber <= 14,"yes")
Thank you, it worked. How can I add if it is from the 15th to the end of the month, it is a "no"? I thought I had the option for a default to No, but it doesn't allow me to do that.