Concatenate two date fields in a View
Posted on 2001-08-08
the case is this:
I have 2 date fields, let us say:
Field 1 ------> StartDate, Type: Date
Field 2 ------> EndDate , Type:date
I have a view and have one column where i need to show the period of StartDate - EndDate in only one column, for example:
01/07/2001 - 30/10/2001
I am writing a formula in that column to concatenate the two date values: @Text(StartDate)+"-"+@Text(EndDate)
but i am getting an error in the column display.
Can you help me to solve this little problem ??
Thanks for your help