Hi,
Below line selects only dates comes after than today.
I need to change below line as "more or equal":
awk -F\## -v d=$(date +%Y%m%d) '{if($NF>d)print}' /usr/batch/pill.txt > /usr/batch/pill_in_use.txt
When we change the code, it will print today's date and following dates only.
Any idea?
thanks in advance
Boris
Without seeing some of the contents of /usr/batch/pill.tx
I have doubts about -F\## giving you what you want as a field separator, but if it currently works matching dates following the given date, the change marked in red should be all you need:
awk -F\## -v d=$(date +%Y%m%d) '{if($NF>=d)print}' /usr/batch/pill.txt > /usr/batch/pill_in_use.txt
Without seeing some of the contents of /usr/batch/pill.tx
I have doubts about -F\## giving you what you want as a field separator, but if it currently works matching dates following the given date, the change marked in red should be all you need:
awk -F\## -v d=$(date +%Y%m%d) '{if($NF>=d)print}' /usr/batch/pill.txt > /usr/batch/pill_in_use.txt
I am gonna test it once again and will let you know.
Thanks
Boris
---------- Post updated at 04:04 PM ---------- Previous update was at 03:56 PM ----------
Dear Don,
That's okay. It's working with this way.
Thanks for your help
Boris