{"id":2490,"date":"2018-02-20T16:17:17","date_gmt":"2018-02-20T16:17:17","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/netsuite-comparer-des-dates-en-ignorant-lheure-a-laide-dune-formule-numerique\/"},"modified":"2026-07-28T18:26:01","modified_gmt":"2026-07-28T18:26:01","slug":"netsuite-comparer-des-dates-en-ignorant-lheure-a-laide-dune-formule-numerique","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/netsuite-comparer-des-dates-en-ignorant-lheure-a-laide-dune-formule-numerique\/","title":{"rendered":"NetSuite : comparer des dates en ignorant l&rsquo;heure \u00e0 l&rsquo;aide d&rsquo;une formule num\u00e9rique"},"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 cr\u00e9er une formule num\u00e9rique dans NetSuite afin de comparer deux champs de date\/horodatage, en veillant \u00e0 ce que seule la partie \u00ab date \u00bb soit prise en compte.","ga_short_answer":"Pour comparer les horodatages NetSuite en fonction de la date uniquement, utilisez un champ \u00ab Formule (num\u00e9rique) \u00bb avec la fonction trunc(). Cette fonction supprime la composante horaire, ce qui permet d\u2019effectuer des comparaisons pr\u00e9cises, bas\u00e9es uniquement sur la date, entre des champs tels que {custbody_date_proceed_sa} et sysdate, en renvoyant 1 pour \u00ab vrai \u00bb et 0 pour \u00ab faux \u00bb en fonction de vos crit\u00e8res.","ga_scenario":"Lors de la comparaison de deux champs d'horodatage dans NetSuite, tels qu'un champ de date personnalis\u00e9 et la date syst\u00e8me actuelle, il est souvent n\u00e9cessaire de ne pas tenir compte de la composante \u00ab heure \u00bb. Les comparaisons standard peuvent donner des r\u00e9sultats inexacts si l'heure de la journ\u00e9e diff\u00e8re, m\u00eame si les dates sont identiques. Une m\u00e9thode est n\u00e9cessaire pour effectuer une comparaison portant uniquement sur la date.","ga_solution":"Pour comparer des horodatages NetSuite sans tenir compte de la composante horaire, vous pouvez utiliser un champ de type \u00ab Formule (num\u00e9rique) \u00bb. Cette approche utilise la fonction trunc(), qui tronque une date ou un horodatage au d\u00e9but de la journ\u00e9e, supprimant ainsi la partie horaire. La formule suivante peut \u00eatre mise en \u0153uvre :CASE WHEN trunc({custbody_date_proceed_sa}) - trunc(sysdate) <= 2 THEN 1 ELSE 0 END Cette formule renvoie 1 si la diff\u00e9rence entre le champ de date personnalis\u00e9 tronqu\u00e9 ({custbody_date_proceed_sa}) et la date syst\u00e8me tronqu\u00e9e (sysdate) est inf\u00e9rieure ou \u00e9gale \u00e0 2 jours, et 0 dans le cas contraire.","ga_source_author":"Samy Lemcelli","ga_source_author_email":"","ga_date_original":"2018-02-20T08:17:17-08:00","ga_date_verified":"2026-07-05","ga_source_subject":"Timestamp comparison in PLSQL","ga_ans_id":"ANS-0014","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-2490","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\/2490","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\/2490\/revisions"}],"predecessor-version":[{"id":2510,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2490\/revisions\/2510"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2490"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2490"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2490"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}