Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 hopkinsc
		
			hopkinsc
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use square brackets around the field name
If(Len([201901]) > 0, 'Yes', 'No') as Complete
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use square brackets around the field name
If(Len([201901]) > 0, 'Yes', 'No') as Complete
 hopkinsc
		
			hopkinsc
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		!!! i can't believe it was that easy!!
Thanks!
