Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Using Len() in the script on a field with a number as a name

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. 

1 Solution

Accepted Solutions
sunny_talwar

Use square brackets around the field name

 

If(Len([201901]) > 0, 'Yes', 'No') as Complete

 

View solution in original post

2 Replies
sunny_talwar

Use square brackets around the field name

 

If(Len([201901]) > 0, 'Yes', 'No') as Complete

 

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

!!! i can't believe it was that easy!!

Thanks!