Try DATE(Calculated field mentioned above), you should get date as required.
1 of 1 people found this helpful
Hi Jayna tan,
str(date(Date)) + " HelloWorld!"
or you could have used the datepart function to pull out the YY, MM, DD and concatenated those.
Hello! i tried the above method however, it only returns the years which is FY2013 but the String isn't present in the label...
Hello! Because the string is added behind the date is different for each value, i cannot add "HelloWorld". Using the datepart extracts the date out but then there won't be the string at the end at the label..