This content has been marked as final. Show 4 replies
I have a script that creates a table of all dates from file names, and I am trying to create a variable from this list to pick out the max date:
For Each vFile in FileList('\D_OO_*.qvd')
Date(Date#(Left(Right('$(vFile)',12),8),'YYYYMMDD'),'DD/MM/YYYY') as [DOO File Date]
LET vStatisticDate = max([DOO File Date]);
My problem is that for some reason the variable vStatisticDate is null, but when I use the exact same expression after the Load I have no problems. What am I doing wrong?