Discussions

Expand all | Collapse all

Converting Date to Text

  • 1.  Converting Date to Text

    Posted 08-18-2021 13:03
    I'm trying to create a field that combines an employee's alphanumeric id from one field, with the date in another field.  

    I can't find a formula that will allow me to link a text field with a date field, but am wondering if I'm able to convert the date to text?

    ------------------------------
    Monica Bridges
    ------------------------------


  • 2.  RE: Converting Date to Text

    Posted 08-18-2021 13:05
    Yes, you can convert most field to text using the ToText function.

    for Example

    List(" ", [Employee ID], ToText(My Date Field]))

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------