Skip to main content

Using Advanced Expressions: To_Varchar

Distributor guide to the TO_VARCHAR advanced expression in Encompass Fusion reports: convert a field to text and set a custom date display format. Needs FusionEdit permission and v23.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.01

Pre-Conditions

  • Required Permission - FusionEdit
    ​
    ​

  • Recommended Fusion I/II Certification

Steps

The TO_VARCHAR function converts the specified expression or field into a string. For date values, you can define the display format to customize how the date appears. VARCHAR stands for “Variable Character” or “Variable-Length Character.” It's a data type in SQL that is used to store strings of text with a variable length.
​
​

Syntax

TO_VARCHAR(source value :: data type , new format)

OR

TO_VARCHAR(source value , new format)
​
​


​Example

TO_VARCHAR("LoadSheets.LoadSheetDate" , 'YYYY.MM.DD') = 2024.11.01

Did this answer your question?