{"id":3763,"date":"2018-04-19T16:02:38","date_gmt":"2018-04-19T16:02:38","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-calculate-the-time-interval-between-dates-in-a-netsuite-saved-search-2\/"},"modified":"2026-07-28T18:26:06","modified_gmt":"2026-07-28T18:26:06","slug":"comment-calculer-lintervalle-de-temps-entre-deux-dates-dans-une-recherche-enregistree-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-lintervalle-de-temps-entre-deux-dates-dans-une-recherche-enregistree-netsuite\/","title":{"rendered":"Comment calculer l&rsquo;intervalle de temps entre deux dates dans une recherche enregistr\u00e9e 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 calculer le nombre total de jours entre la date la plus ancienne et la date la plus r\u00e9cente pour des enregistrements regroup\u00e9s.","ga_short_answer":"Pour calculer l\u2019intervalle, cr\u00e9ez une colonne \u00ab Formule (num\u00e9rique) \u00bb dans votre recherche enregistr\u00e9e. D\u00e9finissez le type de synth\u00e8se sur \u00ab Maximum \u00bb et utilisez la formule `MAX({date}) - MIN({date})`. Cela vous permettra d\u2019obtenir la diff\u00e9rence en jours entre la date la plus r\u00e9cente et la date la plus ancienne pour chaque enregistrement group\u00e9, par exemple par salari\u00e9.","ga_scenario":"Les utilisateurs ont souvent besoin de d\u00e9terminer la dur\u00e9e comprise entre la date la plus ancienne et la date la plus r\u00e9cente enregistr\u00e9es pour des entit\u00e9s sp\u00e9cifiques au sein de NetSuite. Cela implique g\u00e9n\u00e9ralement de calculer le nombre total de jours \u00e9coul\u00e9s entre le premier \u00e9v\u00e9nement enregistr\u00e9 et le plus r\u00e9cent, souvent regroup\u00e9s selon un crit\u00e8re sp\u00e9cifique, tel qu\u2019un salari\u00e9.","ga_solution":"Pour calculer l\u2019intervalle entre la date la plus ancienne et la date la plus r\u00e9cente dans une recherche enregistr\u00e9e NetSuite, <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-apply-advanced-filtering-with-summary-formulas-in-netsuite-saved-searches\/\">configurez une nouvelle colonne<\/a> comme suit : Champ : Formule (num\u00e9rique) Type de synth\u00e8se : Maximum Formule : `MAX({date}) - MIN({date})` Cette configuration renverra le nombre total de jours entre la date la plus r\u00e9cente et la date la plus ancienne enregistr\u00e9es pour chaque entit\u00e9 group\u00e9e. Par exemple, si le regroupement s\u2019effectue par employ\u00e9, l\u2019intervalle sera affich\u00e9 pour chaque employ\u00e9.","ga_source_author":"Dominique Frechette","ga_source_author_email":"","ga_date_original":"2018-04-19T09:02:38-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"Interval Computation in Saved Search","ga_ans_id":"ANS-0104","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],"ga_difficulty":[92],"class_list":["post-3763","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"}],"ga_difficulty":[{"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\/3763","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\/3763\/revisions"}],"predecessor-version":[{"id":5684,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3763\/revisions\/5684"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3763"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3763"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3763"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}