how to get the date-value in shell

hi,

I want to delete the records 15 days ago in a table, but I don't know how to get the dat-value 15 days ago in shell.

                                                   Thanks with regards!

http://forums.unix.com/search.php?action=showresults&searchid=3328&sortby=lastpost&sortorder=descending

thank you so much to reply on it, but DAY=`expr "$DAY" - 1` can't pass the shell, it can't convert "$DAY" into an integer. thanks for telling me more!

Use GNU date and do:

date --date="15 days ago"

or, since the link above seems to be broken, just search the forums for the string "yesterdays date".