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))}
Convert Text to Integer
Re: Convert Text to Integer
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
{((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
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: Convert Text to Integer
Hello,
Please send us a sample report with test data for analysis.
Thank you.
Please send us a sample report with test data for analysis.
Thank you.