{"id":2478,"date":"2019-10-09T19:26:09","date_gmt":"2019-10-09T19:26:09","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-utiliser-la-fonction-semaine-de-lannee-de-la-norme-iso-8601-dans-les-recherches-enregistrees-de-netsuite\/"},"modified":"2026-07-28T18:26:00","modified_gmt":"2026-07-28T18:26:00","slug":"comment-utiliser-la-fonction-semaine-de-lannee-de-la-norme-iso-8601-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-utiliser-la-fonction-semaine-de-lannee-de-la-norme-iso-8601-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Comment utiliser la fonction \u00ab Semaine de l’ann\u00e9e \u00bb de la norme ISO 8601 dans les recherches enregistr\u00e9es de NetSuite ?"},"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":"Ce guide explique comment formater correctement les dates afin d'afficher la semaine et l'ann\u00e9e selon la norme ISO 8601 dans les r\u00e9sultats des recherches enregistr\u00e9es de NetSuite.","ga_short_answer":"Pour aligner la fonction \u00ab Semaine de l'ann\u00e9e \u00bb de NetSuite sur les normes ISO 8601 dans les recherches enregistr\u00e9es, utilisez la syntaxe PL\/SQL sp\u00e9cifique : to_char ( {date} ,'IYYY-IW'). Cette formule garantit que la semaine (IW) et l\u2019ann\u00e9e (IYYY) sont toutes deux calcul\u00e9es conform\u00e9ment aux d\u00e9finitions de la norme ISO 8601, ce qui permet un reporting de dates coh\u00e9rent et reconnu \u00e0 l\u2019\u00e9chelle internationale pour vos donn\u00e9es NetSuite.","ga_scenario":"Les utilisateurs ont souvent besoin que la semaine de l'ann\u00e9e soit affich\u00e9e dans les recherches enregistr\u00e9es de NetSuite \u00e0 des fins de reporting et d'analyse. Les fonctions de date standard de NetSuite ne respectent pas toujours la d\u00e9finition de la norme ISO 8601 concernant la semaine et l'ann\u00e9e, ce qui est essentiel pour les op\u00e9rations internationales et pour garantir la coh\u00e9rence des donn\u00e9es entre diff\u00e9rents syst\u00e8mes. Cela peut entra\u00eener des divergences lors de la comparaison de donn\u00e9es bas\u00e9es sur des dates.","ga_solution":"Pour obtenir un formatage de la \u00ab semaine de l\u2019ann\u00e9e \u00bb conforme \u00e0 la norme ISO 8601 dans les recherches enregistr\u00e9es de NetSuite, vous pouvez utiliser la syntaxe PL\/SQL suivante. Cette m\u00e9thode utilise la fonction `to_char` avec des \u00e9l\u00e9ments de formatage sp\u00e9cifiques afin de garantir le respect de la norme ISO 8601. La syntaxe \u00e0 utiliser est la suivante : to_char ( {date} ,'IYYY-IW') Dans cette formule, `{date}` doit \u00eatre remplac\u00e9 par le champ de date correspondant de votre enregistrement NetSuite. Les \u00e9l\u00e9ments de format `IW` et `IYYY` sont sp\u00e9cialement con\u00e7us pour renvoyer respectivement la semaine et l\u2019ann\u00e9e, conform\u00e9ment \u00e0 la norme ISO 8601.","ga_source_author":"Dominique Frechette","ga_source_author_email":"","ga_date_original":"2019-10-09T12:26:09-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"NetSuite \"Week of Year\" function in Saved Search vs ISO 8601","ga_ans_id":"ANS-0002","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89,89],"ga_difficulty":[92,92],"class_list":["post-2478","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"},{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"},{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2478","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\/2478\/revisions"}],"predecessor-version":[{"id":2498,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2478\/revisions\/2498"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2478"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2478"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2478"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}