Date/Time Format Helper
Convert between Workiva Chains (strftime) and Wdata Tables (Java) date formats with precision timing
Date/Time Format Helper
β
Beta Tool
This tool is in beta and may not detect all date/time formats correctly. If you encounter formats that aren't recognized properly, please let us know via our contact form so we can improve the tool.
Paste a date/time below to detect format strings for Chains and Wdata. If detection fails, you can manually enter a format string using the tokens below.
No match
Enter a format or use the detected one.
No match
Enter a format or use the detected one.
| Meaning | Chains (strftime) | Wdata (Java style) | Example |
|---|---|---|---|
| Day of week (0=Sun..6=Sat) | %w | (n/a) | 2 |
| Full year | %Y | yyyy | 2026 |
| Abbrev. year | %y | yy | 26 |
| Month number (01-12) | %m | MM | 11 |
| Full month name | %B | MMMM | November |
| Abbrev. month name | %b | MMM | Nov |
| Day of month (01-31) | %d | dd | 03 |
| Day of month (no leading zero) | %e | d | 3 |
| Day of year (001-366) | %j | D | 307 |
| Full weekday name | %A | EEEE | Tuesday |
| Abbrev. weekday name | %a | EEE | Tue |
| Hour (00-23) | %H | HH | 18 |
| Hour (01-12) | %I | hh | 06 |
| Minute (00-59) | %M | mm | 37 |
| Second (00-59) | %S | ss | 04 |
| Milliseconds (000-999) | %L | SSS | 432 |
| AM/PM | %p | a | PM |
| Time zone offset (±hhmm) | %z | XXX | +0000 |
| Time zone name/abbr | %Z | z | Coordinated Universal Time |
| ISO date (yyyy-MM-dd) | %F | yyyy-MM-dd | 2026-11-03 |
| Time (HH:mm) | %R | HH:mm | 18:37 |
| Time (HH:mm:ss) | %T | HH:mm:ss | 18:37:04 |
| US date (MM/dd/yy) | %D | MM/dd/yy | 11/03/26 |
| Tab character | %t | (tab) | (tab) |
| Newline character | %n | (newline) | (newline) |
| Percent character | %% | % | % |