{"id":3839,"date":"2017-08-21T14:47:52","date_gmt":"2017-08-21T14:47:52","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-display-the-current-date-and-time-in-a-netsuite-saved-search-2\/"},"modified":"2026-07-28T18:26:10","modified_gmt":"2026-07-28T18:26:10","slug":"comment-afficher-la-date-et-lheure-actuelles-dans-une-recherche-enregistree-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-afficher-la-date-et-lheure-actuelles-dans-une-recherche-enregistree-netsuite\/","title":{"rendered":"Comment afficher la date et l’heure actuelles 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":"D\u00e9couvrez comment configurer un champ de formule dans les recherches enregistr\u00e9es de NetSuite afin d\u2019afficher avec pr\u00e9cision la date et l\u2019heure actuelles pour chaque r\u00e9sultat.","ga_short_answer":"Pour afficher la date et l'heure actuelles dans une recherche enregistr\u00e9e NetSuite, ajoutez une nouvelle colonne de type \u00ab Formule (Texte) \u00bb. Dans le champ de formule, utilisez {now} ou SYSDATE associ\u00e9 \u00e0 la fonction TO_CHAR pour mettre en forme le r\u00e9sultat, en veillant \u00e0 ce que les composantes de date et d'heure soient visibles pour chaque ligne de r\u00e9sultat.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019inclure la date et l\u2019heure exactes auxquelles une recherche enregistr\u00e9e dans NetSuite a \u00e9t\u00e9 ex\u00e9cut\u00e9e, directement dans les r\u00e9sultats de recherche. Cette exigence permet de v\u00e9rifier l\u2019actualit\u00e9 des donn\u00e9es ou de fournir un horodatage pour chaque enregistrement affich\u00e9. Les champs standard ne permettent pas toujours de capturer l\u2019heure d\u2019ex\u00e9cution pr\u00e9cise, ce qui n\u00e9cessite une solution personnalis\u00e9e.","ga_solution":"Pour afficher la date et l\u2019heure actuelles auxquelles une recherche enregistr\u00e9e est ex\u00e9cut\u00e9e, acc\u00e9dez \u00e0 l\u2019onglet \u00ab R\u00e9sultats \u00bb de votre recherche enregistr\u00e9e. Ajoutez un nouveau champ \u00ab Formule \u00bb<\/a>\n\nen s\u00e9lectionnant \u00ab Formule (Texte) \u00bb comme type de champ. Dans la zone de texte \u00ab Formule \u00bb, saisissez l\u2019une des expressions suivantes pour r\u00e9cup\u00e9rer et formater la date et l\u2019heure actuelles, qui seront ensuite affich\u00e9es dans chaque ligne du r\u00e9sultat :\n\n```\nTO_CHAR({now}, 'MM\/DD\/YYYY HH:MI:SS AM')\n```\n\nVous pouvez \u00e9galement utiliser SYSDATE :\n\n```\nTO_CHAR(SYSDATE, 'MM\/DD\/YYYY HH:MI:SS AM')\n```\n\nCette configuration garantit que chaque ligne des r\u00e9sultats de recherche refl\u00e8te fid\u00e8lement la date et l\u2019heure auxquelles la recherche a \u00e9t\u00e9 effectu\u00e9e.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:47:52-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"SOL0144 Date a safe search was executed","ga_ans_id":"ANS-0180","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The exact menu path 'formula(date\/time)' is not explicitly listed as a single selection; 'Formula (Date)' and 'Formula (Text)' are common options for formula fields.; While '{today}' is still accurate for displaying the current date, for displaying both 'date\/time' as implied by the original question, '{now}' or 'SYSDATE' combined with the 'TO_CHAR' function in a 'Formula (Text)' field is typically used to include the time component.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3839","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\/3839","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\/3839\/revisions"}],"predecessor-version":[{"id":5760,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3839\/revisions\/5760"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3839"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3839"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3839"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}