{"id":16248,"date":"2023-05-26T10:53:19","date_gmt":"2023-05-26T03:53:19","guid":{"rendered":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/?post_type=ht_kb&#038;p=16248"},"modified":"2026-01-02T17:07:12","modified_gmt":"2026-01-02T10:07:12","slug":"bo-sung-ham-dateif-khi-dat-cong-thuc-cho-thanh-phan-luong","status":"publish","type":"ht_kb","link":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/bo-sung-ham-dateif-khi-dat-cong-thuc-cho-thanh-phan-luong\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m DATEDIF khi \u0111\u1eb7t c\u00f4ng th\u1ee9c cho th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng"},"content":{"rendered":"<p><a href=\"https:\/\/amis.misa.vn\/ld\/phan-mem-nhan-su-misa-amis?source=Helptienluong&amp;medium=SEO&amp;campaign=bo-sung-ham-dateif-khi-dat-cong-thuc-cho-thanh-phan-luong&amp;content=Banner-sapo-topphanmemnhansu&amp;term=Quynh\"><img decoding=\"async\" class=\"alignnone wp-image-16403 size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2021\/06\/phan-mem-nhan-su-hrm.png\" alt=\"\" width=\"3200\" height=\"977\" \/><\/a><\/p>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong> H\u01b0\u1edbng d\u1eabn HR thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c cho th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n t\u00ednh ra \u0111\u01b0\u1ee3c s\u1ed1 th\u00e1ng l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean k\u1ec3 t\u1eeb ng\u00e0y v\u00e0o l\u00e0m \u0111\u1ebfn th\u00e1ng t\u00ednh l\u01b0\u01a1ng, l\u00e0m c\u0103n c\u1ee9 t\u00ednh ph\u1ee5 c\u1ea5p theo th\u00e2m ni\u00ean c\u00f4ng t\u00e1c.<\/p>\n<p><strong>N\u1ed9i dung:<\/strong><br \/>\n&#8211; S\u1eed d\u1ee5ng h\u00e0m DATEDIF trong c\u00f4ng th\u1ee9c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<br \/>\n&#8211; C\u1ea5u tr\u00fac v\u00e0 tham s\u1ed1 c\u1ee7a h\u00e0m DATEDIF<br \/>\n&#8211; V\u00ed d\u1ee5 minh h\u1ecda t\u00ednh th\u00e2m ni\u00ean theo n\u0103m<\/p>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> HR, K\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, Qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng AMIS Ti\u1ec1n l\u01b0\u01a1ng<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>B\u01b0\u1edbc 1: Truy c\u1eadp ph\u00e2n h\u1ec7 <strong>Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/strong>\\ t\u1ea1i th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111ang thi\u1ebft l\u1eadp HR c\u00f3 th\u1ec3 \u0111\u1eb7t c\u00f4ng th\u1ee9c cho th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng v\u1edbi h\u00e0m DATEDIF. <strong>C\u1ea5u tr\u00fac h\u00e0m: DATEDIF(start_date, end_date, unit).<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2023\/05\/1.1.date-if.png\" alt=\"\" width=\"1600\" height=\"940\" \/><\/p>\n<p><strong>&gt;&gt;&gt; Xem th\u00eam:<\/strong> Top<a href=\"https:\/\/amis.misa.vn\/15047\/phan-mem-tinh-luong\/\" target=\"_blank\" rel=\"noopener\"> ph\u1ea7n m\u1ec1m t\u00ednh l\u01b0\u01a1ng<\/a> nh\u00e2n vi\u00ean mi\u1ec5n ph\u00ed t\u1ed1t nh\u1ea5t<\/p>\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul>\n<li><strong>start_date:<\/strong> L\u00e0 ng\u00e0y th\u00e1ng b\u1eaft \u0111\u1ea7u c\u1ea7n xem x\u00e9t trong ph\u00e9p t\u00ednh. Ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a DATE, h\u00e0m tr\u1ea3 v\u1ec1 lo\u1ea1i DATE ho\u1eb7c s\u1ed1.<\/li>\n<li><strong>end_date:<\/strong> L\u00e0 ng\u00e0y th\u00e1ng k\u1ebft th\u00fac c\u1ea7n xem x\u00e9t trong ph\u00e9p t\u00ednh. Ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a DATE, h\u00e0m tr\u1ea3 v\u1ec1 lo\u1ea1i DATE ho\u1eb7c s\u1ed1.<\/li>\n<li><strong>unit:<\/strong> Vi\u1ebft t\u1eaft d\u1ea1ng v\u0103n b\u1ea3n c\u1ee7a \u0111\u01a1n v\u1ecb th\u1eddi gian. V\u00ed d\u1ee5: &#8220;M&#8221; l\u00e0 th\u00e1ng. Gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ea5p nh\u1eadn l\u00e0 &#8220;Y&#8221;, &#8220;M&#8221;, &#8220;D&#8221;, &#8220;MD&#8221;, &#8220;YM&#8221;, &#8220;YD&#8221;.\n<ul>\n<li>&#8220;Y&#8221;: S\u1ed1 n\u0103m l\u00e0m tr\u00f2n xu\u1ed1ng gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac.<\/li>\n<li>&#8220;M&#8221;: S\u1ed1 th\u00e1ng l\u00e0m tr\u00f2n xu\u1ed1ng gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac.<\/li>\n<li>&#8220;D&#8221;: S\u1ed1 ng\u00e0y gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac.<\/li>\n<li>&#8220;MD&#8221;: S\u1ed1 ng\u00e0y gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac, b\u1ecf qua s\u1ed1 th\u00e1ng.<\/li>\n<li>&#8220;YM&#8221;: S\u1ed1 th\u00e1ng gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac, b\u1ecf qua s\u1ed1 n\u0103m.<\/li>\n<li>&#8220;YD&#8221;: S\u1ed1 ng\u00e0y gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac, gi\u1ea3 s\u1eed ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac c\u00e1ch nhau kh\u00f4ng qu\u00e1 m\u1ed9t n\u0103m.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> HR c\u1ea7n t\u00ednh th\u00e2m ni\u00ean c\u1ee7a nh\u00e2n vi\u00ean t\u00ednh \u0111\u1ebfn th\u1eddi \u0111i\u1ec3m t\u00ednh l\u01b0\u01a1ng, l\u00e0m tr\u00f2n theo s\u1ed1 n\u0103m th\u00ec \u0111\u1eb7t c\u00f4ng th\u1ee9c cho th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng v\u1edbi h\u00e0m DATEDIF, c\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>start_date:<\/strong> s\u1eed d\u1ee5ng th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng Ng\u00e0y th\u1eed vi\u1ec7c (ho\u1eb7c Ng\u00e0y ch\u00ednh th\u1ee9c t\u00f9y theo quy \u0111\u1ecbnh c\u1ee7a \u0111\u01a1n v\u1ecb).<\/li>\n<li><strong>end_date:<\/strong> s\u1eed d\u1ee5ng th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng Th\u00e1ng t\u00ednh l\u01b0\u01a1ng. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng n\u00e0y HR c\u00f3 th\u1ec3 xem trong Danh m\u1ee5c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng c\u1ee7a h\u1ec7 th\u1ed1ng \u0111\u1ec3 \u0111\u01b0a v\u00e0o s\u1eed d\u1ee5ng.<\/li>\n<li><strong>unit:<\/strong> l\u00e0m tr\u00f2n theo s\u1ed1 n\u0103m n\u00ean c\u1ea7n \u0111i\u1ec1n l\u00e0 &#8220;Y&#8221;.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2023\/05\/1.3.date-if.png\" alt=\"\" width=\"1583\" height=\"929\" \/><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n<strong> L\u01b0u<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<p>Khi \u0111\u00f3 tr\u00ean b\u1ea3ng l\u01b0\u01a1ng, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ec3 HR c\u00f3 c\u0103n c\u1ee9 t\u00ednh l\u01b0\u01a1ng theo \u0111\u00fang quy \u0111\u1ecbnh.<\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":107,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[217],"ht-kb-tag":[],"class_list":["post-16248","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r12-phat-hanh-ngay-23-05-2023"],"_links":{"self":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/16248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=16248"}],"version-history":[{"count":4,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/16248\/revisions"}],"predecessor-version":[{"id":18209,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/16248\/revisions\/18209"}],"wp:attachment":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=16248"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=16248"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=16248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}