约会问题 [英] dating issues
问题描述
好的我面对我的数据库的两个任务。
首先我需要从日期(字段)中提取工作日(字段) - 这样当输入日期时,它查看日期并计算日期。香港专业教育学院之前完成了这个,但很久以来就失去了代码,从而产生了工作日。
其次我在我的数据库中有一张表记录学生参加舞蹈课的表,我想要系统连续标记四个非出席者任何类,以提醒系统的操作员,以便他们可以操作一个程序(数据库外部)。
有什么想法吗?
ok im faced with two tasks with my database.
firstly i need to etract a weekday (field) from a date (field) - so that when a date is entered, it looks at the date and calculates the day. ive done this before but long since lost the code to generate a weekday from it.
Secondly i have a table in my database that records the attendance of students to dance classes, i want the system to flag four in a row "non attendances" to any class in order to alert an operator of the system,so that they can then action a procedure(external to the database).
Any ideas?
推荐答案
ok我面临两项任务我的数据库。
首先我需要从日期(字段)中提取工作日(字段) - 这样当输入日期时,它会查看日期并计算当天。香港专业教育学院之前完成了这个,但很久以来就失去了代码,从而产生了工作日。
其次我在我的数据库中有一张表记录学生参加舞蹈课的表,我想要系统连续标记四个非出席者任何类,以提醒系统的操作员,以便他们可以操作一个程序(数据库外部)。
有什么想法吗?
ok im faced with two tasks with my database.
firstly i need to etract a weekday (field) from a date (field) - so that when a date is entered, it looks at the date and calculates the day. ive done this before but long since lost the code to generate a weekday from it.
Secondly i have a table in my database that records the attendance of students to dance classes, i want the system to flag four in a row "non attendances" to any class in order to alert an operator of the system,so that they can then action a procedure(external to the database).
Any ideas?
假设本周的第一天设置为星期日:
Assuming the 1st Day of the Week is set to Sunday:
甚至更简单。
Or even simpler.
甚至更简单。
Or even simpler.
这篇关于约会问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!