Date Format

Default: en-GB · Type: Text

The locale used when the assistant writes dates in explanations (e.g. 31/12/2025 for en-GB vs 12/31/2025 for en-US). This affects prose only, not the SQL itself.

What changes

Dates written in the explanation follow your locale (e.g. 31/12/2025 vs 12/31/2025); the SQL block is identical.

en-GB

Showing tickets opened since 31/12/2025.

sql

SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

en-US

Showing tickets opened since 12/31/2025.

sql

SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

Where to change it

Set this under Profile → Prompt settings in the app. See all AI settings.

Date Format

Where to change it

On this page