{"id":2489,"date":"2018-03-14T18:18:00","date_gmt":"2018-03-14T18:18:00","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-creer-un-filtre-de-date-netsuite-pour-la-semaine-prochaine-et-au-dela\/"},"modified":"2026-07-28T18:26:00","modified_gmt":"2026-07-28T18:26:00","slug":"comment-creer-un-filtre-de-date-netsuite-pour-la-semaine-prochaine-et-au-dela","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-creer-un-filtre-de-date-netsuite-pour-la-semaine-prochaine-et-au-dela\/","title":{"rendered":"Comment cr\u00e9er un filtre de date NetSuite pour la semaine prochaine et au-del\u00e0 ?"},"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 fournit une formule SQL permettant de filtrer avec pr\u00e9cision les r\u00e9sultats d\u2019une recherche enregistr\u00e9e dans NetSuite pour les enregistrements datant du d\u00e9but de la semaine \u00e0 venir.","ga_short_answer":"Pour filtrer les enregistrements NetSuite correspondant \u00e0 des dates commen\u00e7ant la semaine prochaine et s'\u00e9tendant sur une p\u00e9riode donn\u00e9e, utilisez une clause SQL \u00ab between \u00bb. D\u00e9finissez la date de d\u00e9but sur TRUNC(sysdate, 'iw')+7 afin de prendre en compte le d\u00e9but de la semaine suivante. La date de fin sera TRUNC(sysdate, 'iw') + (nombre de jours apr\u00e8s) afin de d\u00e9finir la dur\u00e9e \u00e0 compter du d\u00e9but de la semaine en cours.","ga_scenario":"Les utilisateurs ont souvent besoin que les recherches enregistr\u00e9es dans NetSuite affichent les enregistrements dont les dates se situent dans une p\u00e9riode future sp\u00e9cifique. Une exigence courante consiste \u00e0 filtrer les donn\u00e9es \u00e0 partir du d\u00e9but de la semaine \u00e0 venir et sur un nombre d\u00e9fini de semaines ou de jours suivants. Les filtres de date relatifs standard<\/a> peuvent ne pas r\u00e9pondre pr\u00e9cis\u00e9ment \u00e0 ce besoin, ce qui n\u00e9cessite une formule SQL personnalis\u00e9e.","ga_solution":"Pour mettre en place un filtre de date commen\u00e7ant la semaine prochaine et couvrant la p\u00e9riode suivante, appliquez la formule SQL suivante dans les crit\u00e8res de votre recherche enregistr\u00e9e NetSuite. Cette formule utilise la fonction TRUNC(sysdate, 'iw') pour identifier le d\u00e9but de la semaine ISO en cours, puis calcule le d\u00e9but de la semaine suivante et la date de fin souhait\u00e9e. Utilisez l\u2019expression suivante dans les crit\u00e8res de votre champ de date : `{your date} between (TRUNC(sysdate, 'iw')+7) AND (TRUNC(sysdate, 'iw') + (the number of days after))`. Remplacez `{your date}` par l\u2019identifiant r\u00e9el du champ de date que vous filtrez (par exemple, TRANDATE). Ajustez `(the number of days after)` pour d\u00e9finir la fin exacte de la p\u00e9riode future souhait\u00e9e, par rapport au d\u00e9but de la semaine en cours.","ga_source_author":"Dominique Frechette","ga_source_author_email":"","ga_date_original":"2018-03-14T11:18:00-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"Date filter. Starting next week and including the next 6 weeks.","ga_ans_id":"ANS-0013","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-2489","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\/2489","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\/2489\/revisions"}],"predecessor-version":[{"id":2509,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2489\/revisions\/2509"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2489"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2489"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2489"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}