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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment