Issue with FORMAT use in textboxes when null value

Issue with FORMAT use in textboxes when null value

• Leo Leys

  Please reverse the order of the arguments, and use DateTime format strings as shown in the MSDN documentation:

  * Standard datetime formats:
  http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconstandarddatetimeformatstrings.asp

  * Custom datetime formats:
  http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconstandarddatetimeformatstrings.asp

  In your case, you should try e.g. =Format(Fields!someField.Value, "d")

  Alternatively, you can set the textbox Value property to =Fields!someValue.Value and set the Format property of the textbox to the desired format code.

  -- Robert

  
  
  
• Issue with FORMAT use in textboxes when null value