NUM

[manoranjan_d]

Hi,

I want the below field has to be in num format, so can i declare

Amount

[Chanty4u]

please explain more? which object u need to decalre?

If charts   goto number tab and make it to Number.

if not share some sample

[PrashantSangle]

Hi,

there is num() and num#() available for you.

Regards

[manoranjan_d]

before retrieving the date in the qvd generator i have to retrieve the same date field in num format to make simplification

example:

load

num(createddate) as createddate_num,

date(createddate,'MMDDYYYY') as createddate,

from table.

[PrashantSangle]

Yes got it then what is issue????

Explain in detail bro

Regards,

[Kushal_Chawda]

try this

LOAD *,

         num(YourDate) as DateNum;

SQL SELECT *

FROM Table;

[avinashelite]

if you want to convert string to number than try with num#(field_name)

if you want to format the number than try with num(field_name)

share the sample data that will be helpful for us to suggest the solution

[sujeetsingh]

seems manoranjan just posted this for some entertainment as his name depicts.