Help with current formula for dates

2

hi @Nikki_Donkin , it has been a while, good to see you back again
what about this one:

image
image2421×1100 306 KB 


If(
  thisRow.paydate.Day() < 14,
  Format(
    "Pay Period {1} 14 - {2} 15 {3}",
    thisRow.paydate.EndOfMonth(-1).MonthName(),
    thisRow.paydate.EndOfMonth(0).MonthName(),
    thisRow.paydate.EndOfMonth(0).Year()
  ),
  Format(
    "Pay Period {1} 14 - {2} 15 {3}",
    thisRow.paydate.EndOfMonth(0).MonthName(),
    thisRow.paydate.EndOfMonth(1).MonthName(),
    thisRow.paydate.EndOfMonth(1).Year()
  )
)
2 Likes