CalculateDateTime Problem

Using CalculateDateTime (in an If condition) in a form "When user loads form" gives me the following error. When I take out the CalculateDateTime, the form works fine. I have verified and reverified that MedBIProcData1.DoB is DateTime. The arguments for units, before/after, and (date) from were all entered by the wizard.

CalculateDateTime(18,DateTimeUnits.Years, DateTimeDirection.Before, DateTime.CurrentDate) greater than or equal MedBIProcData1.DoB

Failed to execute deployed method 'FormLoaded', using entity 'MedBI'. Exception 'Cannot cast the DateTime 'Never' to a Double' occurred when attempting to 'Execute workflow '77d823be-6626-44c3-9401-fe6ee69c43a6''. Cannot cast the DateTime 'Never' to a Double

Find more posts tagged with

BPM

Comments

Neil_Hudspeth

The attached is something similar that works for me (in SR2). Look at the Only Start Action If of Conditional Action 1.

Although I can't see the difference between what I posted and what you posted :smileysad:

Neil_Hudspeth

I suspect you are trying to test against an empty date field. Does MedBIProcData1.DoB have a value in it when the test is made?

I have been able to reproduce the error if I test against an empty date field in a modified version of the process I posted, with a condition in ConditionalAction2.

Jerome_Pearce

CalculateDateTime fails when uased with a null date, unlike previous versions.

We reported this some time agoo

Rick Kushner

Thank you very much. It took me a long time to discover that the null date was the problem because I couldn't understand why it was trying to convert to a double, and the error message gave me no clue where the problem occurred.

Do you have a document or some sort of single location to see a complete list of the issues you have found with v.9?

Thanks again!

Jerome_Pearce

most are here: http://metastorm.processmapping.com.au/?forum=157517

some are fixed - please post there if you know of any, preferably with the version the fix is in.