I’m looking to tailor the format of numbers and dates within Novulo to better fit our regional standards. For instance, I’d like to change the number format from xxx,xxx,xxx to xxx.xxx.xxx or simply xxxxxxxxx, and modify the decimal symbol to “.” Additionally, I wish to adjust the date format from dd-MM-yyyy to dd-MM-yy. Could you guide me on where to find these settings in Novulo and what customization options are available?
Hi Stephan,
Novulo uses the standard Dot Net and MSSQL Date formatting strings. See Custom date and time format strings - .NET | Microsoft Learn for more information.
On Date and Datetime-objects, there is a format function.
This formats according to your current locale. It’s very visible with:
datetime:now().format("g")
nl-NL: 2-5-2024 23:43
en-GB: 02/05/2024 23:43
en-US: 5/2/2024 11:43 PM
it’s also visible with floating points and thousands separators, e.g.
float:load(1234.56).format(2)
nl-NL: 1.234,56
en-GB: 1,234.56
en-US: 1,234.56
When you use Novulo Export, you can override the culture here. The culture in the export than overrules the current user.
1 Like