{"id":3821,"date":"2017-08-21T15:31:04","date_gmt":"2017-08-21T15:31:04","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/netsuite-saved-search-calculate-whole-days-between-dates-2\/"},"modified":"2026-07-28T18:26:09","modified_gmt":"2026-07-28T18:26:09","slug":"recherche-enregistree-netsuite-calculer-le-nombre-de-jours-entiers-entre-deux-dates","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/recherche-enregistree-netsuite-calculer-le-nombre-de-jours-entiers-entre-deux-dates\/","title":{"rendered":"Recherche enregistr\u00e9e NetSuite : calculer le nombre de jours entiers entre deux dates"},"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":"D\u00e9terminez avec pr\u00e9cision le nombre de jours entiers entre deux champs de date dans les recherches enregistr\u00e9es de NetSuite en \u00e9liminant les composantes horaires.","ga_short_answer":"Pour calculer le nombre entier de jours entre deux dates dans une recherche enregistr\u00e9e NetSuite, utilisez une formule qui tronque la partie \u00ab heure \u00bb de chaque date avant de les soustraire. La fonction TRUNC supprime l\u2019heure, et la fonction FLOOR garantit que seuls les jours entiers sont pris en compte, ce qui permet d\u2019obtenir une dur\u00e9e pr\u00e9cise.","ga_scenario":"Les utilisateurs ont souvent besoin de calculer le nombre exact de jours complets entre deux champs de date au sein d\u2019une recherche enregistr\u00e9e NetSuite. La difficult\u00e9 survient lorsque les champs de date comportent des composantes horaires, ce qui peut entra\u00eener un d\u00e9compte inexact des jours si cela n\u2019est pas g\u00e9r\u00e9 correctement. Une exigence courante consiste \u00e0 s\u2019assurer que seules les p\u00e9riodes compl\u00e8tes de 24 heures sont prises en compte lors de la d\u00e9termination de la dur\u00e9e.","ga_solution":"Pour obtenir un calcul pr\u00e9cis du nombre de jours entiers entre deux dates dans une recherche enregistr\u00e9e NetSuite, utilisez une formule qui commence par supprimer la partie \u00ab heure \u00bb de chaque date. La fonction TRUNC est recommand\u00e9e \u00e0 cette fin ; il convient ensuite de soustraire les deux dates et d\u2019appliquer la fonction FLOOR pour arrondir \u00e0 l\u2019entier inf\u00e9rieur le plus proche. Cette formule garantit que seules les composantes de date sont compar\u00e9es, ce qui permet d\u2019obtenir un d\u00e9compte pr\u00e9cis des jours entiers. La formule se pr\u00e9senterait comme suit :\n\n```\nFLOOR(TRUNC({date1})-TRUNC({date2}))\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:31:04+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"Drop time portion of a Date in a Saved Search Formula","ga_ans_id":"ANS-0162","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The use of TO_DATE to explicitly 'drop the time portion of a Date' from an existing date\/datetime field is not the most direct or commonly recommended method; TRUNC is more appropriate for this specific task.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3821","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\/3821","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\/3821\/revisions"}],"predecessor-version":[{"id":5742,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3821\/revisions\/5742"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3821"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3821"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3821"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}