how to get Previous Quarter End Date based off of Document Property Value

[David Moore 8]

The goal is to SELECT a date on a calendar input control. Then, determine the previous quarter end date from the selected input control (calendar) selection to apply a date range (ie., startdate & enddate) Trying to replace DateTimeNow() with $({selectedCalendarDate}) // document property value (specifically: $({EndDate}) then StartDate = Previous Quarter End Date

 Works:

Previous Quarter end date: DateAdd("day",-1,DateAdd("quarter",Quarter(DateTimeNow()) - 1,Date(Year(DateTimeNow()),1,1)))

How can I replace DateTimeNow with a value in a document property?

Updating a second document property control based on the value in the first document property control

[Kirsten Smith (she/her)]

You can substitute it with:

DocumentProperty("<doccontrolname>")