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) | 6 |
| Full year | %Y | yyyy | 2025 |
| Abbrev. year | %y | yy | 25 |
| Month number (01-12) | %m | MM | 09 |
| Full month name | %B | MMMM | September |
| Abbrev. month name | %b | MMM | Sep |
| Day of month (01-31) | %d | dd | 13 |
| Day of month (no leading zero) | %e | d | 13 |
| Day of year (001-366) | %j | D | 256 |
| Full weekday name | %A | EEEE | Saturday |
| Abbrev. weekday name | %a | EEE | Sat |
| Hour (00-23) | %H | HH | 20 |
| Hour (01-12) | %I | hh | 08 |
| Minute (00-59) | %M | mm | 03 |
| Second (00-59) | %S | ss | 55 |
| Milliseconds (000-999) | %L | SSS | 167 |
| AM/PM | %p | a | PM |
| Time zone offset (±hhmm) | %z | z | +0000 |
| Time zone name/abbr | %Z | z | Coordinated Universal Time |
| ISO date (yyyy-MM-dd) | %F | yyyy-MM-dd | 2025-09-13 |
| Time (HH:mm) | %R | HH:mm | 20:03 |
| Time (HH:mm:ss) | %T | HH:mm:ss | 20:03:55 |
| US date (MM/dd/yy) | %D | MM/dd/yy | 09/13/25 |
| Tab character | %t | (tab) | (tab) |
| Newline character | %n | (newline) | (newline) |
| Percent character | %% | % | % |