Hi - I`m unable to upload a file because of date formatting. I`ve tried many options with no luck. Any guess what i should input into Time? Thank you.
Hi @CharlieRiera what format is your date field in? it looks like YYYY-MM-DD.
So if you use the details in Patterns with separators.
Y represents year number (1, 2 or 4 digits)
M Repesents month number (1 or 2 digits)
D represents day number in month.
Can you see which one from the list to use then?
Laurance
Hi Charlie,
You will type the format YYYY-MM-DD manually under the section 'Fixed Position Patterns'. This is usually more effective than changing the format in the csv. as when transferring the location of the csv. the date structure may revert back.
Happy to help further.
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
