i have a formula like that
filter(lookup('Table A','CreatedDate'),totext(lookup('Table A','Approved')) = 'yes')
which returns an array of dates I want to get the last date of them ?
i have a formula like that
filter(lookup('Table A','CreatedDate'),totext(lookup('Table A','Approved')) = 'yes')
which returns an array of dates I want to get the last date of them ?
Hi,
I you are sure that dates will always have a length of 10 characters (MM/DD/YYYY or DD-MM-YYYY) you can combine the join() and right() function.
The final function would be
right(join(filter(lookup('Table A','CreatedDate'),totext(lookup('Table A','Approved')) = 'yes')),10)
Regards
Frederik
thanks for your reply but it shows
Error with formula: 1 argument was given to the function join, it must instead be given exactly 2 arguments
My mistake, I did copy/pasted the formula correct. This should work:
right(join(filter(lookup('Table A','CreatedDate'),totext(lookup('Table A','Approved')) = 'yes'),' '),10)
The part I inserted between the parentheses of 'yes'))
is the second parameter of the join() function and indicates which character is used between the values. In this case, it is a space.