Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please i want to know how to apply MoneyFormat to a field of LOAD statement?
Thanks for your help.
I didn't get your question right! Could you please explain briefly! So that we can help you out...
Hello Yimen,
Try with
Money(CurrencyField) AS Field
That will return the number value stored in CurrencyField following the format stored in your MoneyFormat at the beginning of your script.
Regards.
HI Yiemn,
You can change the format in the edit script main page Which is by default
'SET MoneyFormat='$#,##0.00;($#,##0.00)';' you can change it as you want and can load the data in the format you want.
Regards
Sunil
HI Yiemn,
Rather if you want to change the MoneyFormat for a single field you can Use the MoneyFormat( ) Function avaliable in the Foramttin Function Catagory in the edit script.
Regards
Sunil