Tag Archives: Func_Dates
DDay(StartDay,EndDay)
DDay is a function within ddGlobal and forms part of the ddDate suite of macros. It is use to calculate the “Difference” between two dates that is in the numeric format YYYYMMDD. It assumes there is only 360 days in … Continue reading
ddInTCK(Startdate,EndDate)
ddInTCK is a function within ddGlobal and forms part of the ddDate suite of macros. It is based on the famous, or infamous (depending on your point of view), SAS function called InTCK It will basically take two dates that … Continue reading
BuildCurDate()
BuildCurDate is a function within ddGlobal and forms part of the ddDate suite of macros. The macro is straight forward and will use the current date (today), using the excel formula +now() and convert it into the text format YYYY-MM. … Continue reading
ConvertDate(ActiveDate, Optional IsFromSas)
ConvertDate is a function within ddGlobal and forms part of the ddDate suite of macros. It is used to convert various formats of dates into the text format YYYY-MM. Excel dates counts the days from January 01, 1900 up words. … Continue reading
ConvertToDays(ActiveDate)
ConvertToDays is a function within ddGlobal and forms part of the ddDate suite of macros. It is used to calculate the number of days that there is in the text value “YYYY-MM” from. This has limited use in Excel but … Continue reading
LargeDate(TheRange)
LargeDate is a function within ddGlobal and forms part of the ddDate suite of macros. It is use to obtain the largest date in a series of YYYY-MM text formatted dates. See the below example: TheRange 2013-03 2012-03 2005-01 2000-11 … Continue reading
CleanDate(ActiveDate)
CleanDate(ActiveDate) CleanDate and ddCleanDate are both functions within ddGlobal and forms part of the ddDate suite of macros. ddCleandate is kept just for compatibility with older spreadsheets but works the same as CleanDate. CleanDate will take various formats of numbers … Continue reading
ddBuildDate(ActiveDate,Increment,Optional=OutFormat)
ddBuildDate is a function within ddGlobal which forms part of the ddDate suite of macros. ddBuildDate uses the text field “YYYY-MM” or the numeric format “YYYYMM” to do date calculations on. So assume you have a number “200506” (June 2005) … Continue reading