SYS08 Employee Details

The data in the "Start Date" row is blank and I've tried three different formulas (LOOKUP, CODE, & PARENT) and none of them are working. What formula do I need? The first & second images are related to this question.

Also, why is this post directed towards the "Japan Community"? The third image is related to this question.

Comments

Rnilsson

The date is an imported.
You thus need to have the Date format on the line item when importing the file. (as you have done)
However, you also need to pick the correct time mapping to match the format in the source. if you have Y-M-D YYMMDD or D-M-Y or M-D-Y or any other option in the source file.

brianoliver20

Thank you @Rnilsson for your quick response.

I reloaded the "Employees" .csv file, however, I didn't see an option to adjust the date format. Here are a few images below that might give you some clues:

Rnilsson

Screenshot 2023-12-07 at 21.49.14.png

Note the following area.
If the line item is not a mapping but just data load, you will have the settings here

brianoliver20

Ah! I never would have noticed those buttons.

Thank you for your help!

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…