Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there a work around for using the LEN() function in the script on a field that has a numeric name?
Basically, i have a field with the name of 201901, and if i try and use an IF(LEN()) in the script it returns the wrong result but if i change the field name to be 'FIELD' then the if statement returns the correct result.
Any ideas?
I have attached an example.
Use square brackets around the field name
If(Len([201901]) > 0, 'Yes', 'No') as Complete
Use square brackets around the field name
If(Len([201901]) > 0, 'Yes', 'No') as Complete
!!! i can't believe it was that easy!!
Thanks!