This may be a little confusing as it has been for me so please bare with me. I have an expiration date and want it to automatically create a due date that falls into either the 12/30 end of year group or 6/30 middle of the year group.
As an example:
I have a record with a expiration date of "01/01/2023". I want it to fall into the group of 06/30/2022 as 12/30/2022 would be to close of a due date. Id like at least a few month gap in-between dates so it gives us preparation time.
I'm using a date picker for the due date and a date picker for the expiration. When I pick the expiration date I'd like it to auto fill the due by date.
Here is the code I'm currently playing with. Not the best written as I'm sure there is something better out there.
This code would'nt work due to the year change and not giving me a few months gap. Pretty embarrassing, lol. Hard to wrap my head around this.
If(Value(DateValue(ThisItem.CertExpiration),"[$-en-US] mm/dd/yyyy") < Value(DateValue("06/29"),"[$-en-US] mm/dd") , Text(DateValue("6/30/" & Text(DateValue(ThisItem.CertExpiration),"[$-en-US] yyyy") ),"[$-en-US] mm/dd/yyyy"),Text(DateValue("12/30/" & Text(DateValue(ThisItem.CertExpiration),"[$-en-US] yyyy") ),"[$-en-US] mm/dd/yyyy"))
