var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sql syntax for yesterday's business date?
Do you guys know what the syntax would be for getting yesterday's business date?
I think there is a weekday function.....I was thinking something to the effect of WEEKDAY(TODAY)-1
I need to create a parameter for yesterday's business date. Although, the syntax above returns no results.
Last edited by Beebo; 06-03-09 at 18:37.
try: weekday(today - 1 units day)
Patrick, I was not able to pull back any results with that syntax.
select weekday(today - 1 units day) from systables where tabid = 1
should returns in dbaccess.
SELECT * FROM database.table WHERE column = today -1