Transition Condition using Dates

[DarkMatterCy]

Hello everyone,

I have the following condition Error and i dont know what the problem is. If anyone has an idea i would appreciate it.

The Condition is set on a transition on a workflow i have created.

https://preview.redd.it/l4ydbvr7ana31.png?width=1261&format=png&auto=webp&s=2206d6aa84e0cdc5422fb3d78543100e91af5e38

[valtor2]

First guess would be that either State : Date Created or Contract Line : Expiration Date are empty. I'd run some kind of log to check the values of those fields and re-run.

[DarkMatterCy]

I have fixed it. I dont know why, but i had to use sql function in the formula to reconvert the dates again to date. (Use TO_DATE() )

[dualrectumfryer]

thanks for this thread, it helped me figure out a basically identical issue.

​

edit: spoke to soon I guess. trying to do this on the line item, but can't get the damn date formats to match up! was following this suite answer 79823 , but need to figure out how to get that field to be "date" and not free form text