locked
Date Formula RRS feed

  • Question

  • User-797751191 posted

    Hi

      I have below code . I want that only Date should be displayed & in dd/MM/yyyy format.

    "Ledger From : " & {?@frDate} & " To " & {?@toDate}

    Thanks

    Monday, November 25, 2019 6:35 AM

Answers

  • User-1716253493 posted

    Use ToText() to format the the date

    and CDate to convert the parameter value to date datatype, if it's not

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 28, 2019 6:42 AM

All replies

  • User765422875 posted

    example

    var date = DateTime.Now;
    var dateString = date.ToString("dd'/'MM'/'yyyy", CultureInfo.InvariantCulture);

    Thursday, November 28, 2019 12:49 AM
  • User-1716253493 posted

    Use ToText() to format the the date

    and CDate to convert the parameter value to date datatype, if it's not

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 28, 2019 6:42 AM