Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to put the date format like '30-AUG-11'. I can get to '30-Aug-11', but i need the month to be written in capital letters. Thanks
Sorry I don't understand..
You are not using a script? I think QV will not load anything without a script.
Maybe you used the assistant from the start page to open the excel file? This will also create a script, go to file-->edit script or use CTRL-E
You should see some line with
LOAD
...
from ...
There should be a field name indicating your date column in excel, either named or something like @1.
use the upper function on that fieldname and rename the field with as (as given by Sunil).
Or use upper(yourfield) in any expression (list box), text field etc.
Or do you want something totally different from that?
try upper() function, like in
=upper(Date(today(),'DD-MMM-YYYY'))
Regards,
Stefan
i believe only upper can be used
upper(datefieldname)
The problem is i get the date from an excel file like '20-AUG-11'. If I go to file settings, numbers and date how do i tell it to put the letters as capital letters?
while fetching in script
upper(datefieldname) as datefieldname
I don#t have a common script. The only thing i do is to hold data from excels, so the date i get is in a colum of the file.
Sorry I don't understand..
You are not using a script? I think QV will not load anything without a script.
Maybe you used the assistant from the start page to open the excel file? This will also create a script, go to file-->edit script or use CTRL-E
You should see some line with
LOAD
...
from ...
There should be a field name indicating your date column in excel, either named or something like @1.
use the upper function on that fieldname and rename the field with as (as given by Sunil).
Or use upper(yourfield) in any expression (list box), text field etc.
Or do you want something totally different from that?