Numerical value established by a formula not seen as a number

latheobald89201

Hello

I have used the mid formula to break down a date and indicate the number of the month only in a field. =MID([Start Date]@row, 2, 1). This is all working fine. I want to run an automation where if the value of this field is less than 5 do x. However it is not seeing the value as a number and is thus returning zero rows that meet this criteria. What is the solution to this issue?

Thank you

VBAGuru

Try

=Value(MID([Start Date]@row, 2, 1))

VBAGuru

Try

=Value(MID([Start Date]@row, 2, 1))

latheobald89201

@VBAGuru Thank you that was the exact solution.