I have a shell script which should read file in a shared area with date in filename.

e.g: filename : abc_26042011.csv

shell script generated by tool that I am using :
SET LOAD_FILE="<Directory Path>\abc_26042011.csv"

Since there will be new file everyday, how can I modify this script to take filename with latest date?

In unix shell
LOAD_FILE="dirpath/abc_$(date +%d%m%Y).csv"
or
LOAD_FILE="dirpath/abc_`date +%d%m%Y`.csv"

However it seems you are not using unix shell

Thanks for that ...

I tried but both the cases it gives me file not found error
File "H:\Spend_tree_exports\SPT_EXPECTION_LOB_INDIRECT_ $(date +mY).csv" was not found.


I am basically using a DW tool that automatically generate scripts as below for loading process

@echo off
setlocal enabledelayedexpansion
setlocal enableextensions


SET LOAD_FILE="H:\Spend_tree_exports\SPT_EXPECTION_LOB _INDIRECT_$(date +%d%m%Y).csv"

You are talking about batch programs on Windows - not shell scripts, right?