Format a Date to "DD/MM", e.g.3/11 instead of 3/11/2014

• Sanjeev Jha-475652

  Say Hey Kid

  Points: 704

  More actions

  March 11, 2014 at 4:43 pm

  #289228

  Hello,

  The column has dates, a letter "Y", and some blank fields. I tried an expression as below and it shows an error and previewed.

  =iif(isnothing(Fields!BB_Delivers_BOM.Value), "N/A",

  iif(Fields!BB_Delivers_BOM.Value = "Y", "Y",

  CStr(Month(Fields!BB_Delivers_BOM.Value)) & "/" & Cstr(Day(Fields!BB_Delivers_BOM.Value))

  )

  )

  This does convert the full date to day/month but for other criteria it shows

  #Error

  . How can I solve this? Any tip(s)? I appreciate your help in advance. Thank you!