{"id":6706,"date":"2024-02-14T15:29:23","date_gmt":"2024-02-14T14:29:23","guid":{"rendered":"https:\/\/app.lib.uliege.be\/alma\/?p=6706"},"modified":"2024-02-14T15:29:23","modified_gmt":"2024-02-14T14:29:23","slug":"calculer-un-ecart-entre-deux-champs-date","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/calculer-un-ecart-entre-deux-champs-date\/","title":{"rendered":"Calculer un \u00e9cart entre deux champs \u00ab\u00a0date\u00a0\u00bb"},"content":{"rendered":"\n<p>La formule suivante permet de calculer un \u00e9cart de jours\/semaines\/mois\/ann\u00e9es entre deux champs de type \u00ab\u00a0expr.date\u00a0\u00bb<\/p>\n\n\n\n<p><strong>TIMESTAMPDIFF(SQL_TSI_DAY\/WEEK\/MONTH\/YEAR, expr, expr)<\/strong><\/p>\n\n\n\n<p>Exemple :<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>TIMESTAMPDIFF(SQL_TSI_DAY, \u00ab\u00a0Portfolio PO Line\u00a0\u00bb.\u00a0\u00bbSent Date\u00a0\u00bb, \u00ab\u00a0Portfolio Activation Date\u00a0\u00bb.\u00a0\u00bbPortfolio Activation Date\u00a0\u00bb)<\/p>\n<\/blockquote>\n\n\n\n<p>Cette formule permet de calculer le nombre de jours entre la date d&rsquo;envoi de la PO line au fournisseur et celle o\u00f9 le portfolio est activ\u00e9.<\/p>\n\n\n\n<p>Il est \u00e9galement possible de mesurer l&rsquo;\u00e9cart entre un champ date et la date du jour.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>TIMESTAMPDIFF(SQL_TSI_YEAR, \u00ab\u00a0Item Creation Date\u00a0\u00bb.\u00a0\u00bbItem Creation Date\u00a0\u00bb, CURRENT_DATE)<\/p>\n<\/blockquote>\n\n\n\n<p>Cette formule permet de calculer le nombre d&rsquo;ann\u00e9es entre la date de cr\u00e9ation d&rsquo;un exemplaire et la date du jour.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La formule suivante permet de calculer un \u00e9cart de jours\/semaines\/mois\/ann\u00e9es entre deux champs de type \u00ab\u00a0expr.date\u00a0\u00bb TIMESTAMPDIFF(SQL_TSI_DAY\/WEEK\/MONTH\/YEAR, expr, expr) Exemple : TIMESTAMPDIFF(SQL_TSI_DAY, \u00ab\u00a0Portfolio PO Line\u00a0\u00bb.\u00a0\u00bbSent Date\u00a0\u00bb, \u00ab\u00a0Portfolio Activation Date\u00a0\u00bb.\u00a0\u00bbPortfolio Activation Date\u00a0\u00bb) Cette formule permet de calculer le nombre de jours entre la date d&rsquo;envoi de la PO line au fournisseur&#8230; <a href=\"https:\/\/services.lib.uliege.be\/alma\/calculer-un-ecart-entre-deux-champs-date\/\" class=\"readmore\">Lire l&#039;int\u00e9gralit\u00e9&#8230;<span class=\"screen-reader-text\">Calculer un \u00e9cart entre deux champs \u00ab\u00a0date\u00a0\u00bb<\/span><span class=\"fa fa-angle-double-right\" aria-hidden=\"true\"><\/span><\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-6706","post","type-post","status-publish","format-standard","hentry","category-analytics","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-1Ka","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/6706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/comments?post=6706"}],"version-history":[{"count":1,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/6706\/revisions"}],"predecessor-version":[{"id":6708,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/6706\/revisions\/6708"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=6706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=6706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=6706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}