Hi
just spent some time visiting casual dating sites - not a good idea;-)
OK I have three fields all text and I want to concatenate them into a single field and convert them to a date format so I can sort ascending
So I know that cdate is the way to go and that the & is used to concatenate.
I seem unable to find out how to use cdate to do this on the web hence my visits to funny web sites.
I assume I do it as an expression in a query? and not at table level?
as usual any help appreciated
thanks
Ian