员工回国周年纪念日

发布于 2025-01-13 08:36:01 字数 837 浏览 2 评论 0原文

我正在尝试查询我为 Zoho 中的计划导入设置的人员配置表。我的目标是查询当月有周年纪念日的所有员工。下面是我要编写的查询，但看起来 Zoho 不允许使用 GETDATE 函数。有什么建议吗？

    SELECT
        "Department",
        "EmployeeID",
        "FirstNameLastName",
        "LastNameFirstName",
        "MGR_FirstLast",
        "MGR_LastFirst",
        "StartDate",
        "status",
        "TermDate",
        "wasp_emp_key"
    WHERE "StartDate">=DATEADD(mm,DATEDIFF(mm,0,GETDATE())-12,0)
     AND
     "StartDate"< DATEADD(mm,DATEDIFF(mm,0,GETDATE())-11,0)     


UPDTATE - SOLUTION BELOW

SELECT
    "Department",
    "EmployeeID",
    "FirstNameLastName",
    "LastNameFirstName",
    "MGR_FirstLast",
    "MGR_LastFirst",
    "StartDate",
    "status",
    "TermDate",
    "wasp_emp_key"
FROM "Eagle_Employee_EmploymentDates_Status"
WHERE MONTH("StartDate")  = MONTH(CURDATE())

原文

I am trying to query a staffing table I have set for scheduled imports into Zoho. My goal is to query all of the employees that have an anniversary in the current month. Below is the query I would write, but it looks like Zoho does not allow for GETDATE function. Any suggestions?

    SELECT
        "Department",
        "EmployeeID",
        "FirstNameLastName",
        "LastNameFirstName",
        "MGR_FirstLast",
        "MGR_LastFirst",
        "StartDate",
        "status",
        "TermDate",
        "wasp_emp_key"
    WHERE "StartDate">=DATEADD(mm,DATEDIFF(mm,0,GETDATE())-12,0)
     AND
     "StartDate"< DATEADD(mm,DATEDIFF(mm,0,GETDATE())-11,0)     


UPDTATE - SOLUTION BELOW

SELECT
    "Department",
    "EmployeeID",
    "FirstNameLastName",
    "LastNameFirstName",
    "MGR_FirstLast",
    "MGR_LastFirst",
    "StartDate",
    "status",
    "TermDate",
    "wasp_emp_key"
FROM "Eagle_Employee_EmploymentDates_Status"
WHERE MONTH("StartDate")  = MONTH(CURDATE())

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

南风起 2025-01-20 08:36:01

SELECT
    "Department",
    "EmployeeID",
    "FirstNameLastName",
    "LastNameFirstName",
    "MGR_FirstLast",
    "MGR_LastFirst",
    "StartDate",
    "status",
    "TermDate",
    "wasp_emp_key"
FROM "Eagle_Employee_EmploymentDates_Status"
WHERE MONTH("StartDate")  = MONTH(CURDATE())

SELECT
    "Department",
    "EmployeeID",
    "FirstNameLastName",
    "LastNameFirstName",
    "MGR_FirstLast",
    "MGR_LastFirst",
    "StartDate",
    "status",
    "TermDate",
    "wasp_emp_key"
FROM "Eagle_Employee_EmploymentDates_Status"
WHERE MONTH("StartDate")  = MONTH(CURDATE())

回复收藏 0 原文

~没有更多了~