PS: I need to get SQLDate (YYYY-MM-DD) and I feel that I will have to do it by myself…).
Emile, is this the sort of thing you want? set cd to current date display dialog my sqlConversion(cd) set cd2 to cd - days * 6 display dialog my sqlConversion(cd2) set cd3 to cd set month of cd3 to 5 display dialog my sqlConversion(cd3) set month of cd3 to February # being the 31st today, the extra 3 days will 'spill over' into March display dialog my sqlConversion(cd3) set cd4 to date "1 4 2012" display dialog my sqlConversion(cd4)
on sqlConversion(cd) set d to day of cd if d < 10 then set d to "0" & d set m to month of cd as number if m < 10 then set m to "0" & m set sqlDate to year of cd & "-" & m & "-" & d as text return sqlDate end sqlConversion
|