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.
=+BuildCurDate()
If I run this now, I will get the answer “2013-03″.
Please note that it uses the function “CleanDate” as discussed in another post.
Function BuildCurDate() As String 'Function that will build the current date in the format YYYY-MM 'Written by Denis BuildCurDate = Year(Now) & "-" & Month(Now) BuildCurDate = CleanDate(BuildCurDate) End Function