Below is some useful code I have used many times. This allows you to take a date field and display the month of the field. I have used this in categorised columns many times for many years. You have to make sure that if the month number is less than 10 that you prepend a "0", otherwise the month of 11 would become "JanuaryJanuary".
tmpDate:= @Month(StartDate);
tmpTxtDate:= @If(tmpDate<9;"0"+@Text(tmpDate);@Text(tmpDate));
tmpMonths := "January":"February":"March":"April":"May":"June":"July":"August":"September":"October":"November":"December";
tmpNum := "01":"02":"03":"04":"05":"06":"07":"08":"09":"10":"11":"12";
@ReplaceSubstring(tmpTxtDate;tmpNum;tmpMonths)
No comments:
Post a Comment