输入一个日期,怎么在程序或者SQL里面确定这天所属的周的开始日期与结束日期? 输入一个日期,怎么在程序或者SQL里面确定这天所属的周的开始日期与结束日期?怎么确定这个月的结束日期? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 i := DateOfWeek(Now);if i = 1 then ShowMessage('今天是周日')else if i = 2 then ShowMessage('今天是周一'); MonthDays[IsLeapYear(Y), M] 能得到这个月有多少天,再判断录入的日期的日是不是等于这个月的天数,如果相等于就是月末 { CurDate由用户输入}var WeekBeginDate, WeekEndDate: TDatetime; ... WeekBeginDate := IncDay(CurDate, 1 - DayOfTheWeek(CurDate)); WeekEndDate := IncDay(CurDate, 7 - DayOfTheWeek(CurDate)); ...var CurYear, CurMonth, CurDay, DaysOfMonth: Word; MonthEndDate: TDatetime; ... DecodeDate(CurDate, CurYear, CurMonth, CurDay); DaysOfMonth := DaysInAMonth(CurYear, CurMonth); MonthEndDate := IncDay(CurDate, DaysOfMonth - CurDay); ... 得到周一: if dayofweek(date)=1 then week1:=date-6 //具体是6还是7你自己算. else week1:=date-dayofweek(date);得到周日: week7:=week1+6;得到月初:参考ddqqyy(ddqqyy)的办法; 月初是curmonth的1日. 月末是curmonth+1月的第一日减去1天,当然,还要考虑12月和1月. 好了,告诉你一个比较酷的单元DateUtils,里面有大量的日期函数:1.返回星期一的日期(给定日期所在周):StartOfTheWeek(now);2.返回星期日的日期(给定日期所在周):EndOfTheWeek(now); 针对月份的:1.StartOfTheMonth(now)2.EndOfTheMonth(now)针对年的:1.StartOfTheYear(now)2.EndOfTheYear(now) Byte数组问题 fastreport乱码 在函数中中止程序运行 FTP的PORT模式和PASV模式的问题。谢谢高手。 图片从数据库中调出并显示在TWEBBrowser控件中 堆叠报表,挑战quickreport高手!!! 一个简单的sql语句,请帮忙! 有谁在“鲨鱼丸”(www.whatisnet.net)下过东西吗?要怎么下啊? 如何在 SQL 中实现一个 FOR......DO 的循环???? 知道年月日,如何知道是星期几? 不用字符串,如何将单个汉字赋给一个字符变量? 1,DBGrid 中如何显示88.88%这种格式?2,count(..)/count(..)如何显示为float型?
if i = 1 then
ShowMessage('今天是周日')
else if i = 2 then
ShowMessage('今天是周一');
CurDate由用户输入
}var
WeekBeginDate, WeekEndDate: TDatetime;
...
WeekBeginDate := IncDay(CurDate, 1 - DayOfTheWeek(CurDate));
WeekEndDate := IncDay(CurDate, 7 - DayOfTheWeek(CurDate));
...var
CurYear, CurMonth, CurDay, DaysOfMonth: Word;
MonthEndDate: TDatetime; ...
DecodeDate(CurDate, CurYear, CurMonth, CurDay);
DaysOfMonth := DaysInAMonth(CurYear, CurMonth);
MonthEndDate := IncDay(CurDate, DaysOfMonth - CurDay);
...
if dayofweek(date)=1 then week1:=date-6 //具体是6还是7你自己算.
else week1:=date-dayofweek(date);得到周日:
week7:=week1+6;得到月初:参考ddqqyy(ddqqyy)的办法;
月初是curmonth的1日.
月末是curmonth+1月的第一日减去1天,当然,还要考虑12月和1月.
1.返回星期一的日期(给定日期所在周):StartOfTheWeek(now);
2.返回星期日的日期(给定日期所在周):EndOfTheWeek(now);
1.StartOfTheMonth(now)
2.EndOfTheMonth(now)
针对年的:
1.StartOfTheYear(now)
2.EndOfTheYear(now)