{"id":3746,"date":"2017-08-21T14:39:31","date_gmt":"2017-08-21T14:39:31","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-calculate-the-number-of-days-in-a-month-in-netsuite-2\/"},"modified":"2026-07-28T18:26:05","modified_gmt":"2026-07-28T18:26:05","slug":"comment-calculer-le-nombre-de-jours-dans-un-mois-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-le-nombre-de-jours-dans-un-mois-dans-netsuite\/","title":{"rendered":"Comment calculer le nombre de jours dans un mois dans 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":"Les utilisateurs de NetSuite peuvent d\u00e9terminer le nombre exact de jours d'un mois donn\u00e9 \u00e0 l'aide d'une simple formule de calcul de date.","ga_short_answer":"Pour calculer le nombre de jours dans un mois dans NetSuite, appliquez la formule LAST_DAY({trandate}) - TRUNC({trandate},'MONTH')+1. Cette formule soustrait le premier jour du mois du dernier jour, puis ajoute un pour prendre en compte tous les jours.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin de d\u00e9terminer le nombre pr\u00e9cis de jours dans un mois donn\u00e9 \u00e0 des fins de reporting, de champs personnalis\u00e9s ou d\u2019autres calculs. Ce besoin se fait sentir lors de <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-calculate-fiscal-year-start-date-in-netsuite-saved-searches-for-non-calendar-fiscal-years\/\">la cr\u00e9ation de solutions personnalis\u00e9es qui reposent sur des plages de dates mensuelles pr\u00e9cises<\/a>.","ga_solution":"Pour obtenir le nombre de jours dans un mois dans NetSuite, utilisez la formule suivante : LAST_DAY({trandate}) - TRUNC({trandate},'MONTH')+1. Le composant LAST_DAY({trandate}) identifie le dernier jour du mois. La fonction TRUNC({trandate},'MONTH') identifie le premier jour du mois. La soustraction du premier jour au dernier jour donne la diff\u00e9rence entre les deux dates. L\u2019ajout de +1 \u00e0 cette diff\u00e9rence donne le nombre total de jours du mois. Bien que {trandate} soit utilis\u00e9 dans cet exemple, toute valeur de date valide peut \u00eatre substitu\u00e9e.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:39:31-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Number of days in a month","ga_ans_id":"ANS-0087","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":[12],"ga_difficulty":[93],"class_list":["post-3746","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-saved-search-developer","ga_difficulty-debutant"],"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":12,"label":"Saved search developer"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3746","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\/3746\/revisions"}],"predecessor-version":[{"id":5667,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3746\/revisions\/5667"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3746"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3746"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3746"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}