メインコンテンツまでスキップ

logoCorrectSize.png

Looks like this logo isn't being used anymore since we started using the new CSS to make our documentation look like our product UI.

Knowledge @ Adaptive Insights LLC, a Workday Company

Calendar time codes are displaying numbers instead of dates

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release. 

Question

I am updating my calendar and after the import I see that my time codes are displaying numbers instead of dates.

Answer

This can occur when the code column is formatted as date because the importer converts the Excel date format to Excel's numeric value for the dates. To correct this, you can convert the column values to text and then run the import again. One easy way to do so would be by using the 'Text to Columns' option within Excel.

  • text to columns.png

 

  • この記事は役に立ちましたか?