• Joanna Kirk
  • NEWBIE
  • 20 Points
  • Member since 2015
  • CLOUT!

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 5
    Replies
Hi everyone!

My validation rule, below, works, but I need to make it possible for this field to be left blank:

IF(Value(fieldname) > Year(TODAY()),true,IF(LEN(fieldname)=4,false,true))

- I think I need to add something but not sure where to start

IF (not(isblank(fieldname)), 
    ????????????,
NULL)


I have not yet go my head around the syntax! 
e.g. trading since (year)

I've been told to start with a number field (4 digit limit) but need a hint on where to start with the sytax! Any help appreciated.
Hi everyone!

My validation rule, below, works, but I need to make it possible for this field to be left blank:

IF(Value(fieldname) > Year(TODAY()),true,IF(LEN(fieldname)=4,false,true))

- I think I need to add something but not sure where to start

IF (not(isblank(fieldname)), 
    ????????????,
NULL)


I have not yet go my head around the syntax! 
e.g. trading since (year)

I've been told to start with a number field (4 digit limit) but need a hint on where to start with the sytax! Any help appreciated.