By using this website, you agree to our Terms of Use (click here)
Hi Everyone
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
Try:
=CDate([SOShipment.LastModifiedDateTime]) - CDate([SOShipment.ShipDate])
@roycelithgo Thanks Royce. I tried it but unforutnately adding the CDate did not change the results
Try this:
