it works now - but it's very strange and the worst is, I have no idea why it works now and didn't work before ...
I wrapped the date (in the old format 'DD.MM.YYYY') in quoted and in another DATE() function now - that way works.
=> It now looks like >> DATE('$(v_current_date)') <<
That with the decimals could be - but actually I use the very same DATE() function on the very same table twice - first I aggregate the base_file to a table holding all the distinct dates and then I parse that to split the very same base_file into slices - so there's no apparent reason why the results should not be comparable ... I'll try anyway.
Hmm interesting, I was thinking the decimals was causing problems if it wasn't treated the value as a proper number and so failing the date function. If that's not the case though I'm not sure, would be good if you could upload an example or your full script.
As you say should be fine if it's form the same base file