I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both dates, start and ending dates to the column.
This code returns the dates in wrong format. It returns them in something like this 41523 but I would like it to return them in dd/mm/yyyy.
But if I put just [StartDate] or [EndingDate] all alone to the calculated column, everything works just fine.