How can the date format be modified in the UiPath Insights Dashboard?
Issue Description:
Customers want to change the date format to DD/MM/YYYY in the UiPath Insights Dashboard, but are unsure how to configure it properly.
By default, UiPath Insights uses standard SQL-compatible date formats, which may not display the date in the desired day/month/year format.
By default, for date parts, the only accepted separators and formats are ., /,-, and no separator (like yyyymmdd) and YYYY-MM-DD.
Resolution :
Create a Custom Dimension on the insights dashboard and mention the expression below
concat(if(extract_days(${jobs_org.end_date}) < 10,
concat("0", extract_days(${jobs_org.end_date})),
concat("", extract_days(${jobs_org.end_date}))
),
"-",
if(extract_months(${jobs_org.end_date}) < 10,
concat("0", extract_months(${jobs_org.end_date})),
concat("", extract_months(${jobs_org.end_date}))
),
"-",
extract_years(${jobs_org.end_date})
)
Result: Once the query is executed, the date columns appear in the format shown below:
