年假格式 [英] Annual leave format

问题描述

大家好，

我正在尝试一些年假数据库。

它的想法是


年假： [雇用日期] + 1，第1年= 14天

第2年= 14 +（14 + 1）

。

。

。

我需要在我的情况下执行年假的表达式。关于！

Hi All,
Am trying some Annual leave database.
It''s Idea is

Annual leave:[Date of Employ]+1,for 1st year=14 days
for 2nd year=14+(14+1)
.
.
.
I need the expression which execute Annual leave in my case. with regard!

推荐答案

我认为我明白你的政策是就业年限* 14 + 1 。我猜测可能有一个截止点，否则一旦你工作了13年，你只需要工作半年。所以我们需要更详细地说明政策是什么。


您还在寻找VBA或SQL解决方案吗？

I think that I understand your policy to be Years of Employment * 14 + 1. I''m guessing that there is probably a cutoff, otherwise once you have worked 13 years, you would only have to work half the year. So we need a more detailed explanation of what the policy is.

Also are you looking for a VBA or SQL solution?

感谢您的支持关注！@Seth

无论员工在公司工作多少年。但是，员工必须在新的Entitle天发布之前的一年内没有任何日期消费。第一年有权享受年假。仅在第一年使用，除非有一些例外情况。我需要基于SQL。

标题为第1天，从14天开始

第2年，14天+ 15天= 29天

它是这样的。

Thanks for your concern!@Seth
No matter how many year employee can work in the company.However,employee has to consume entitled no of days within the year before new Entitle days released.The first year entitled annual leave shall be used on that first year only unless some exceptional case.I need SQL based.
Entitled Days for 1st,begin with 14 days
2nd year,14 days + 15 Days = 29 Days
it goes like this.

你能展示你的作品吗？


我要做的是 Allen Browne'年龄（）功能的变体


在查询中使用此功能，将雇用的雇用日期提供给它。现在你有了年龄公司的员工。

（个人而言，我会在一个领域做到这一点）


然后你可以使用iif（年龄=> 1,14 +（14+（年龄-1）），14）

（就个人而言，我会在第二个领域做到这一点......但是，可以在一个领域完成所有这一切）


如上所述，这将从0岁到1.999999（...）默认为14天，如果您不想在1之前奖励，则需要额外的逻辑一年周年纪念日，如果你需要一个截止时间，例如只有60天等等......你可以用嵌套的IIF（）来做，或者我的偏好是，切换功能（，因为我发现嵌套的iif（）很难维护。）

Can you show your work?

What I would do is a variation on Allen Browne''s Age() Function

Using this function in the query, feed it the employ''s hire date. Now you have the "Age" of the employee with the company.
(personally, I''d do this in one field)

You can then use iif(age=>1,14+(14+(age-1)),14)
(personally, I''d do this in a second field... however, could do this all in one field)

As written, this will default to 14 days from age 0 thru age 1.999999(...), You will need additional logic if you don''t want to award before the 1 year anniversary and if you need a cutoff such as only 60 days, etc... you can do this with nested IIF() or, my preference would be, Switch Funciton (,as I find nested iif() to be difficult to maintain).

这篇关于年假格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！