{"id":1015,"date":"2008-10-12T23:04:26","date_gmt":"2008-10-13T06:04:26","guid":{"rendered":"http:\/\/members.crystalreportsbook.com\/books\/?p=1015"},"modified":"2012-05-08T10:33:47","modified_gmt":"2012-05-08T17:33:47","slug":"9-7-date-and-time-functions","status":"publish","type":"post","link":"http:\/\/www.crystalreportsonlinetraining.com\/training\/9-7-date-and-time-functions\/","title":{"rendered":"9.07 Date and Time Functions"},"content":{"rendered":"

Date and Time Functions<\/h1>\n

Table 9-10. Date and Time Functions<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Function Name<\/th>\nDescription<\/th>\n<\/tr>\n
CurrentDate, CurrentTime,CurrentDateTime<\/td>\nReturns the current date and\/or time.<\/td>\n<\/tr>\n
DateSerial(year, month, day),DateTime(hour, minute, second)<\/td>\nReturns a date or time.<\/td>\n<\/tr>\n
DateAdd(interval, number, date)<\/td>\nIncreases the date by a certain interval.<\/td>\n<\/tr>\n
DateDiff(interval, startdate, enddate, firstdayofweek)<\/td>\nFinds the difference between two dates.<\/td>\n<\/tr>\n
DatePart(interval, date, firstdayofweek, firstweekofyear)<\/td>\nReturns a number representing the current interval of a date.<\/td>\n<\/tr>\n
MonthName(integer, abbreviate)<\/td>\nReturns the full month name. Return the 3-letter abbreviation if the second parameter is True.<\/td>\n<\/tr>\n
Timer<\/td>\nThe number of seconds that have elapsed since midnight.<\/td>\n<\/tr>\n
WeekDay(date, firstdayofweek)<\/td>\nReturns a number representing the day of the week.<\/td>\n<\/tr>\n
WeekdayName(weekday, abbreviate, firstdayofweek)<\/td>\nReturns the full month name. Return the 3-letter abbreviation if the second parameter is True.<\/td>\n<\/tr>\n<\/table>\n

Table 9-11. Interval Strings for DateAdd(), DateDiff() and DatePart()<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
String<\/th>\nDescription<\/th>\n<\/tr>\n
“yyyy”<\/td>\nYear<\/td>\n<\/tr>\n
“q”<\/td>\nQuarter<\/td>\n<\/tr>\n
“m”<\/td>\nMonth (1 through 12)<\/td>\n<\/tr>\n
“ww”<\/td>\nWeek of the year (1 through 53)<\/td>\n<\/tr>\n
“w”<\/td>\nDay of the week (1 through 7)<\/td>\n<\/tr>\n
“y”<\/td>\nDay of year (1 through 366)<\/td>\n<\/tr>\n
“d”<\/td>\nDay part of the date (1 through 31)<\/td>\n<\/tr>\n
“h”<\/td>\nHour<\/td>\n<\/tr>\n
“n”<\/td>\nMinute<\/td>\n<\/tr>\n
“s”<\/td>\nSecond<\/td>\n<\/tr>\n<\/table>\n

The date and time functions that come with .NET pale in comparison to what you can do with Crystal Reports. Although many of the Basic syntax functions are similar to their .NET counterparts, they give you more functionality. You can also combine different functions together to create very powerful date calculations. There are a lot of new concepts to learn.<\/p>\n","protected":false},"excerpt":{"rendered":"

Date and Time Functions Table 9-10. Date and Time Functions Function Name Description CurrentDate, CurrentTime,CurrentDateTime Returns the current date and\/or time. DateSerial(year, month, day),DateTime(hour, minute, second) Returns a date or time. DateAdd(interval, number, date) Increases the date by a certain interval. DateDiff(interval, startdate, enddate, firstdayofweek) Finds the difference between two dates. DatePart(interval, date, firstdayofweek, firstweekofyear) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,40],"tags":[],"class_list":["post-1015","post","type-post","status-publish","format-standard","hentry","category-chapter-9-built-in-functions","category-crystal-reportsnet-2008","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/1015","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=1015"}],"version-history":[{"count":2,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/1015\/revisions"}],"predecessor-version":[{"id":1919,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/1015\/revisions\/1919"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=1015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=1015"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=1015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}