{"id":358,"date":"2007-12-30T21:46:28","date_gmt":"2007-12-31T04:46:28","guid":{"rendered":"http:\/\/members.crystalreportsbook.com\/crystal-reports-xi\/b10-date-and-time-functions\/"},"modified":"2011-05-26T23:17:36","modified_gmt":"2011-05-27T06:17:36","slug":"b10-date-and-time-functions","status":"publish","type":"post","link":"http:\/\/www.crystalreportsonlinetraining.com\/training\/b10-date-and-time-functions\/","title":{"rendered":"B.9 Date and Time Functions"},"content":{"rendered":"<p><strong>Table 6-10. Date and Time Functions<\/strong><\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<th>Basic Syntax<\/th>\n<th>Crystal Syntax<\/th>\n<\/tr>\n<tr>\n<td>CurrentDate, CurrentTime,<\/td>\n<td>CurrentDateTime<\/td>\n<\/tr>\n<tr>\n<td>CurrentDate, CurrentTime,<\/td>\n<td>CurrentDateTime<\/td>\n<\/tr>\n<tr>\n<td>DateSerial(year, month, day),<\/td>\n<td>DateTime(hour, minute, second)<\/td>\n<\/tr>\n<tr>\n<td>DateSerial(year, month, day),<\/td>\n<td>DateTime(hour, minute, second)<\/td>\n<\/tr>\n<tr>\n<td>DateAdd(interval, number, date)<\/td>\n<td>DateAdd(interval, number, date)<\/td>\n<\/tr>\n<tr>\n<td>DateDiff(interval, startdate, enddate, firstdayofweek)<\/td>\n<td>DateDiff(interval, startdate, enddate, firstdayofweek)<\/td>\n<\/tr>\n<tr>\n<td>DatePart(interval, date, firstdayofweek, firstweekofyear)<\/td>\n<td>DatePart(interval, date, firstdayofweek, firstweekofyear)<\/td>\n<\/tr>\n<tr>\n<td>MonthName(date, abbreviate)<\/td>\n<td>MonthName(date, abbreviate)<\/td>\n<\/tr>\n<tr>\n<td>Timer<\/td>\n<td>Timer<\/td>\n<\/tr>\n<tr>\n<td>WeekDay(date, firstdayofweek)<\/td>\n<td>DayOfWeek(date, firstdayofweek)<\/td>\n<\/tr>\n<tr>\n<td>WeekdayName(weekday, abbreviate, firstdayofweek)<\/td>\n<td>WeekdayName(weekday, abbreviate, firstdayofweek)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Table 6-10. Date and Time Functions Basic Syntax Crystal Syntax CurrentDate, CurrentTime, CurrentDateTime CurrentDate, CurrentTime, CurrentDateTime DateSerial(year, month, day), DateTime(hour, minute, second) DateSerial(year, month, day), DateTime(hour, minute, second) DateAdd(interval, number, date) DateAdd(interval, number, date) DateDiff(interval, startdate, enddate, firstdayofweek) DateDiff(interval, startdate, enddate, firstdayofweek) DatePart(interval, date, firstdayofweek, firstweekofyear) DatePart(interval, date, firstdayofweek, firstweekofyear) MonthName(date, abbreviate) MonthName(date, abbreviate) Timer [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,1],"tags":[],"class_list":["post-358","post","type-post","status-publish","format-standard","hentry","category-appendix-b-basic-syntax-reference","category-crystal-reports-xi","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/comments?post=358"}],"version-history":[{"count":1,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/358\/revisions"}],"predecessor-version":[{"id":1900,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/358\/revisions\/1900"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=358"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}