Hi coda people!
I’m trying to make a billing document for me, and I’m a little stuck on one field.
I have a column which is 'Last Paid" - a date field. I have another column ‘Pay Period’ which I’d like to create a formula for. If Last Paid is after the 14th of x month, but before the 15th of y month, then 'Pay Period x - y" would fill in the Pay Period column.
I had this set up
“If(thisRow.[Last Paid]>Date(2021,10,14).And(thisRow.[Last Paid]>Date(2021,11,14)),“Pay Period 15 Oct - 14 Nov 2021”,”"), however, it fills in the same thing for every field no matter that the date is. Any help is appreciated