Convert Text to Integer

[dwabare92]

Hi guys,

Running into an issue with this...I do believe that I am failing to understand how to convert to an integer which is why my formula is failing...can you take a look?

{DateDiff(PLDet._Data.Relation4.Relation3.User_Date2, Today)/ (Int32.PLDet._Data.Relation.Relation6.User_Text2))}

[dwabare92]

Update: I've got what I believe to be the formula

{((DateDiff(Today, PLDet._Data.Relation.User_Date1) .Days)*(-1))/((Int32.Parse(PLDet._Data.Relation.Relation6.User_Text2))*30)}

However; it is giving me a value of 0 which leads me to believe that I've got to convert this to a date afterwards? "((Int32.Parse(PLDet._Data.Relation.Relation6.User_Text2))*30)}" The idea would be to turn it to days i.e. 6*30=180 days

[Lech Kulikowski]

Hello,

Please send us a sample report with test data for analysis.

Thank you.