I am trying to combine two date columns in impromptu to give the result series 7 by the way
for example 01-01-2000 to 02-02-2002
it is important that I see the word 'to' in the column, so have converted the date to a string using
date-to-string (Valid from) + 'to'date-to-string (Date of Last Order)...
This works fine, but the resultant date is not in UK format, it is yyyy-mm-dd, I need dd-mm-yyyy
Any suggestions would be gratefully received