{"id":2614,"date":"2017-08-21T15:12:45","date_gmt":"2017-08-21T15:12:45","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-resoudre-les-incompatibilites-de-format-de-date-entre-netsuite-et-les-importations-csv\/"},"modified":"2026-07-28T18:25:04","modified_gmt":"2026-07-28T18:25:04","slug":"comment-resoudre-les-incompatibilites-de-format-de-date-entre-netsuite-et-les-importations-csv","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-resoudre-les-incompatibilites-de-format-de-date-entre-netsuite-et-les-importations-csv\/","title":{"rendered":"Comment r\u00e9soudre les incompatibilit\u00e9s de format de date entre NetSuite et les importations CSV"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Assurez-vous que l'importation des donn\u00e9es s'effectue correctement en harmonisant les param\u00e8tres de date dans NetSuite avec le format utilis\u00e9 dans vos fichiers CSV.","ga_short_answer":"Pour r\u00e9soudre les probl\u00e8mes de formatage des dates lors de l\u2019importation de fichiers CSV dans NetSuite, la m\u00e9thode la plus efficace consiste \u00e0 vous assurer que le format de date d\u00e9fini dans vos pr\u00e9f\u00e9rences utilisateur NetSuite correspond exactement au format de date utilis\u00e9 dans votre fichier CSV. Le formatage personnalis\u00e9 d\u2019Excel ne donne pas toujours les r\u00e9sultats escompt\u00e9s lors des importations.","ga_scenario":"Les utilisateurs rencontrent souvent des difficult\u00e9s lors de <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-effectively-use-external-ids-for-netsuite-csv-imports\/\">l\u2019importation de donn\u00e9es \u00e0 partir de fichiers CSV dans NetSuite<\/a>, en particulier lorsque des champs de date sont concern\u00e9s. Les tentatives de reformatage des dates directement dans les tableurs \u00e0 l\u2019aide de formats personnalis\u00e9s ne permettent pas toujours de r\u00e9soudre le probl\u00e8me, ce qui peut entra\u00eener des erreurs d\u2019importation ou des interpr\u00e9tations erron\u00e9es des dates.","ga_solution":"La m\u00e9thode la plus fiable pour \u00e9viter les divergences de formatage des dates lors <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-ensure-accurate-item-references-in-netsuite-csv-imports\/\">des importations CSV dans NetSuite<\/a> consiste \u00e0 synchroniser les formats de date. Cette m\u00e9thode s\u2019est av\u00e9r\u00e9e plus efficace que de tenter de d\u00e9finir des formats de date personnalis\u00e9s au sein m\u00eame du tableur.\n1. Modifiez les pr\u00e9f\u00e9rences utilisateur dans NetSuite afin qu\u2019elles correspondent au format de date pr\u00e9sent dans le fichier .csv.\n2. Assurez-vous que le format de date du fichier .csv (par exemple, mm\/jj\/aaaa ou jj\/mm\/aaaa) est identique au format configur\u00e9 dans NetSuite.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:12:45-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to change date formatting in excel: mm\/dd\/yyyy to dd\/mm\/yyyy","ga_ans_id":"ANS-0875","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"CSV Import & Data Migration","footnotes":""},"ga_category":[20,96,96],"ga_audience":[45],"ga_difficulty":[93],"class_list":["post-2614","qa_entry","type-qa_entry","status-publish","hentry","ga_category-csv-import-data-migration","ga_category-import-csv-et-migration-de-donnees","ga_audience-end-user","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":20,"label":"CSV Import & Data Migration"},{"value":96,"label":"Import CSV et migration de donn\u00e9es"},{"value":96,"label":"Import CSV et migration de donn\u00e9es"}],"ga_audience":[{"value":45,"label":"End user"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2614\/revisions"}],"predecessor-version":[{"id":4534,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2614\/revisions\/4534"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2614"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2614"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2614"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}