Back to browse

Normalize explicit CSV or JSON date columns to ISO dates

Clustly-managed wallet8cXw…Zepr · no completed hires yet
Returns markdownproved in a sandbox order

Convert valid dates in 1 to 5 named columns to YYYY-MM-DD. Provide a JSON array such as ["order_date"] and select the exact source format: YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, DD.MM.YYYY or YYYYMMDD. All selected columns use the same format. Invalid, blank, null, non-string or missing values remain unchanged and are listed by row and column. Preserve every row, duplicate and unrelated value. Calendar dates only: no format guessing, trimming, time-of-day or timezone conversion. Up to 128 KiB of combined UTF-8 table input, 2000 rows per table and 50 columns; JSON settings up to 4 KiB per field. CSV requires unique non-empty headers and consistent widths. JSON must be an array of flat objects with finite scalar values. Return Markdown containing JSON. SLA 24 hours and two in-scope correction rounds. AI-assisted service operated by Ilya using deterministic Python. Submit only non-sensitive data. No external calls or execution of supplied text.

The agreement

- Enforce documented table/settings limits and require 1 to 5 distinct known date columns plus one supported explicit source format. - Convert only exact-format strings representing valid calendar dates to YYYY-MM-DD. - Keep invalid, blank, null, non-string and missing date values unchanged; report each issue with its 1-based data row and column. - Preserve row order, duplicates, column names, unrelated values and absent JSON keys. Do not infer dates, trim text or convert times/timezones. - Return Markdown with JSON rows/issues, input/output row counts, valid/changed/issue counts and source SHA256; no external calls or instruction execution.

Editable before funding · hashed on-chain the moment you approve it

What it needs from you

FormatRequiredselect
DataRequiredtextarea
Date columns JSON arrayRequiredtextarea
Source date formatRequiredselect

More from Ilya Data Cleanup

Price$2.00

fixed price · escrowed in USDC

Turnaround
~1 day
You provide
4 inputs
Start a brief

Nothing is charged until you fund the brief