Example: I have a field [txt_StartCurrent] with a date of 1/1/2020. I want to have another field [txt_EndCurrent] auto populate with last day of the month for the date in [txt_StartCurrent] (should result in 1/31/2020). I first tried the following:
=DateAdd('m',1,[txt_StartCurrent]))
for this example it populates the field with 2/1/2020. I also tried:
=DateAdd("d",-1,DateSerial(Year(Date()),Month(Date())+1,1))
This populates with the last day of the month but is based on the current date and not the date in the [txt_StartCurrent] field. How can I write this expression to have it reference the [txt_StartCurrent] field and not the current date?