TimeSpan.FromDays(). ....???? (format result of TimeSpan.FromDays () ONLY WITH HH:MM

• DZN61

  SSChasing Mays

  Points: 628

  More actions

  July 16, 2012 at 6:29 am

  #264215

  Hi,

  Could somebody help me with this?

  I'm gettting the milliseconds with TImeSpan.FromDays(fieldname).tostring()

  How avoid this ? How format the result of timeSpan?

  I have tried with formatdatetime() but does not work.

  Tks in advance.

• Conficker

  SSCommitted

  Points: 1507

  More actions

  July 19, 2012 at 7:35 am

  #1514842

  try

  =FORMAT(<date>,"dd/MM/yyyy")