Format Dates And Numbers

Use these transformation types when the whole value is correct in meaning but wrong in format.

Date Format

Use this when the value should become a date.

Field used:

• Date Format Pattern

What it does:

• Tries normal date parsing first.
• Also recognizes these date styles:
  • YYYY-MM-DD
  • MM/DD/YYYY
  • DD.MM.YYYY
  • YYYYMMDD
• Rejects invalid dates such as impossible month or day values.
• Rejects weekday-prefixed text such as Mon 15 Jan 2024.

Important:

• The pattern field is a hint for the user. It does not force strict parsing.

Examples:

Before	Rule	After
2024-12-25	Date Format	12/25/2024
12/25/2024	Date Format	12/25/2024
25.12.2024	Date Format	12/25/2024
20241225	Date Format	12/25/2024

Number Format

Use this when the value should become a decimal number.

Field used:

• Number Format Pattern

What it does:

• Tries normal number parsing first.
• Removes common currency symbols such as $, €, £, ¥, and ₹.
• Handles both styles below:
  • 1,234.56
  • 1.234,56
• Handles comma-only decimal values such as 12,5.

Important:

• The pattern field is a hint for the user. It does not force strict parsing.
• Text currency codes such as USD are not removed automatically.
• If a non-empty value cannot be parsed, the current behavior can return 0.

Examples:

Before	Rule	After
1,234.56	Number Format	1234.56
1.234,56	Number Format	1234.56
$1,500.00	Number Format	1500
12,5	Number Format	12.5

Practical checks

• Use Date Format when the whole value is a date in the wrong style.
• Use Number Format when the whole value is a number in the wrong style.
• If the value includes extra words or codes you need to strip out first, use a different transformation type instead of forcing the formatter to guess.