RELATIVEPATH returns the relative path from an actual path to the target path.
Both arguments must be strings with absolute paths. The actual path is optional, if omitted the current dir is used instead. In case the volume drive letters don't match, an absolute path will be returned.
If a relative path is returned, it always starts with '.\' or '..\'
rel_path = RELATIVEPATH( target_path, actual_path )
One more bug - this function alway adds "\" on to the end of the result:
relativepath( 'c:\temp\1.txt', 'C:\temp') = '.\1.txt\'
results in lowercase letters...
works great on mac, does it also work on windows?
worked fine, good examples
very good! many thanks!