Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date format

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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?

View solution in original post

6 Replies
swuehl
MVP
MVP

try upper() function, like in

=upper(Date(today(),'DD-MMM-YYYY'))

Regards,

Stefan

SunilChauhan
Champion
Champion

i believe only upper can be used

upper(datefieldname)

Sunil Chauhan
Not applicable
Author

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?

SunilChauhan
Champion
Champion

while fetching in script

upper(datefieldname) as  datefieldname

Sunil Chauhan
Not applicable
Author

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.

swuehl
MVP
MVP

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?