Description
The function shortDate returns a shortened version of the specified date. Optionally, the culture (culture) can be specified to adjust the formatting to a specific localization.
Syntax
shortDate(date, [culture])
Arguments
| Argument | Description |
|---|---|
date |
The date to be formatted. |
culture (optional) |
The optional specification of the localization or culture (e.g. "de-DE" for German or "en-US" for English). If no culture is specified, the default culture is used. |
Return Types
The function returns a date in a short format, e.g. DD.MM.YYYY for "de-DE" or MM/DD/YYYY for "en-US".
Examples
| Description | Formula | Result |
|---|---|---|
| Short date without specifying a culture |
shortDate("2024-12-06")
|
06.12.2024 |
| Short date with German localization |
shortDate("2024-12-06", "de-DE")
|
06.12.2024 |
| Short date with US localization |
shortDate("2024-12-06", "en-US")
|
12/06/2024 |
Notes
- The date formatting depends on the specified culture (
culture). - If no culture is specified, the system's default culture is used.
Comments
0 comments
Please sign in to leave a comment.