Has anyone come across U/SQL and Date Functions

[Corvu]

Can anyone please help?

I have just inherited a big headache. I have a Corvu database running of a language called U/Sql, I've never heard of it, nor anyone I know. The only literature I can find says it is similar to ANSI SQL. My problem is I desperately need a date function that returns data from the previous month eg: between date()-30 and date()-1 or similar. The only date function I can find that works in U/SQL is {fn CURDATE()}. Has anyone ever seen this or got any ideas?

Nic

 

[rac2]

In SQL Server -
MONTH(date) is equivalent to DATEPART(mm, date).

In Access -
Month(date)

These functions return the number(1 through 12) of the month for a date.

There is a website for a company named Cor Vu, maybe they can help.

http://www.support.corvu.com/