Skip to main content
Question

I need a formula for a certain time of the month to equal yes or no.

  • August 6, 2018
  • 0 replies
  • 32 views

I need a formula stating if date created occurred between the  1st and the 14th, yes is the value in the field. 
This topic has been closed for replies.

Try this

var number DayNumber = Day(ToDate([Date Created]));

IF($DayNumber >=1 and $DayNumber <= 14,"yes")