Title / Description
Code IF( WEEKDAY( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) ) >3, ( YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) ) AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) <3 ) OR ( YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_SUB( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) , INTERVAL 1 WEEK ) ) AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) >2 ), ( YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_SUB( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) , INTERVAL 1 WEEK ) ) AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) <3 ) OR ( YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_SUB( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) , INTERVAL 2 WEEK ) ) AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) >2 ) )
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code