Hi Everyone,
I have a column in joined list which contains date, I need to add specific days which I have checked with if, like if payment is X when 30 if payment is Y then 60. The issue is coming when I am using math to add date with days, it is return a number only not a date and I suppose the joined list does not return the date as format in date.
Any suggestions how to convert the joined list column into date.
Thanks
This would be correct, but the way you are describing it and attempting to use a math column with the joined list column, it sounds like it only ever returns a single date.
I guess my first questions would be…do you ever expect more than one value, and why are you using a joined list instead of a Lookup column or Single Value column
So, I have a payment table which includes this all information, while in user table I have query create to display the latest payment for which I am using look up form query, and then converting this to joined list to use for calculations. so it will always be one value as query is restricted to 1.
I would just change the query to only return a single row in the query column configuration, and then use the lookup column, which will be a single date type value instead of an array.
Turn this off.
On a side note, you never need to create a joined list on top of a lookup. You could skip a step and have the joined list directly refer to the relation or query instead. You don’t need a joined list in this case, but just wanted to make you aware.
Thanks Jeff, it worked.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
