Hi
Is there any equivalent function in WEBFOCUS as that of TRUNC in ORACLE.

Thanks
Naveen.
WF 7.1.6

What are you trying to do?

i am trying to get the system date and calculate the previous month's start date.

I was trying with the ORACLE query , taking the sysdate , truncating it for the previous month.

But i want to bypass the database hit . . .

so i am using the today() function of webfocus to get the sysdate.After that i want to calculate the start date of the "Previous quarter" or the "previous month"
So i was looking for the TRUNC like function . . .

Thanks
Naveen.
WF 7.1.6

WebFocus Reporting does not have an equivalent of TRUNC that can be used in DEFINE or COMPUTE.


However you can do the equivalent using formating options for your output

For instance if you have a column called ORIGINAL with a format of D10.6 and a value of 123.123456

PRINT ORIGINAL ORIGINAL/D10.1

would produce 123.123456 123.1

as its output

Sorry Navin you want the other use of trunc

use the DATEMOV subroutine it does the equivalent

JG . ..

Thanks for the DATEMOV function . . that works well for me .

Thanks
Naveen.