ok have written some script that changes
standard UK date format dd/mm/yyyy to mysql query
format yyyymmdd
is there a better way of doing this?
standard UK date format dd/mm/yyyy to mysql query
format yyyymmdd
Code:
whenstart =date()
motdaynumsql = day(whenstart)
motmonthsql = month(whenstart)
motyearsql = year(whenstart)
'sql start
daysql = motdaynumsql
if daysql < 10 then
daysql = "0" & daysql
end if
monthsql = motmonthsql
if monthsql < 10 then
monthsql = "0" & monthsql
end if
'join together
dstartdatesql = motyear & monthsql & daysql
is there a better way of doing this?