var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date calculation
I want to calculate the following date: Starting from todays date, deducted by one month and the 12th of of that month.
Today is 15.Nov.2012
Result should be: 12.Oct.2012
Is there any easier way than this one (I did that, but looks quite complex to me for this simple request, there should be an easier way using not so many functions as this will slow down the speed)
date(trim(Char(YEAR(CURRENT DATE - 1 MONTH)))||'-'|| trim(Char(MONTH(CURRENT DATE - 1 MONTH)))||'-12')
current date - 1 month - day(current date) days + 12 days
Perfect! That was what I am looking for!
It is inappropriate to post the same question on multuiple forums