Page 1 of 1

Convert Text to Integer

Posted: Wed Oct 19, 2022 9:09 pm
by 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))}

Re: Convert Text to Integer

Posted: Wed Oct 19, 2022 9:48 pm
by 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

Re: Convert Text to Integer

Posted: Thu Oct 20, 2022 9:25 am
by Lech Kulikowski
Hello,

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

Thank you.