I have tried searching the mail archives but I am unable to find anything to do with the current week number. Can anyone tell me if there is a way to get/use the current week number? I would like to use the current week number as the table name to store syslog(NG) messages. syslog-ng --version syslog-ng 1.6.8 My syslog-ng.conf options { sync (0); time_reopen (10); log_fifo_size (1000); long_hostnames (off); use_dns (no); use_fqdn (no); create_dirs (no); keep_hostname (yes); }; source s_sys { file ("/proc/kmsg" log_prefix("kernel: ")); unix-stream ("/dev/log"); internal(); udp(ip(0.0.0.0) port(514)); }; destination d_mysql_syslog { pipe("/var/lib/mysql/mysql.pipe" template("INSERT INTO $WEEKNUMBER (host, facility, priority, level, tag, date, time, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n") template-escape(yes)); }; log { source(s_sys); destination(d_mysql_syslog); }; Any assistance would be greatly appreciated. -- John This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.