Jump to content
We've recently updated our Privacy Statement, available here. ×

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


David Moore 8

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...