In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Formula comparing last created with ship date wont work
I am trying to create a field in the shipment generic inquiry to show me if a last modified date is after the ship date
I created the following field, but am not getting the desired result. I believe the problem may be that the last modified date includes a time stamp so they are not directly comparable. Any ideas? Below is the formula that I have been using
=IIf( ([SOShipment.LastModifiedDateTime] )>[SOShipment.ShipDate_Day],1,2 )
In a perfect world what is would like to know is how many days the last modified date exceeds the ship date
Any ideas would be appreciated
=CDate([SOShipment.LastModifiedDateTime]) - CDate([SOShipment.ShipDate])