Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I read the filename as the monthname.
Monthname(Date#(Left(Filename(), 5 ),'MMMYY')) as Monthname_Amt
Now, in each month file, there is a "Document Date".
I would like to eliminate those rows with Document Date not equal to the current monthname.
For example: In Jun19 file, there are May19 and Jun19 document date, but I do not want to read May19 rows.
How to do it? Please help.
Thank you.