2 Replies Latest reply: May 15, 2014 10:15 AM by PYelton _ RSS

    How do you set a Date field to Null?

    PYelton _

      I want to create a calculated field of type Date and set the value to Null based on an expression:  For example If(Field1 = X,{01/01/2013},(Null)).  I can do it by making the calculated field a Character type instead, but that's a bit cumbersome considering some other things I'm doing with the data.  What's the correct way, if any,  to do this?

       

      Many Thanks!

       

      Paul

      V9.5