topic Date format in QlikView

Date format

Tue, 30 Aug 2011 12:55:20 GMT

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

Date format

swuehl — Tue, 30 Aug 2011 13:02:13 GMT

try upper() function, like in

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

Regards,

Stefan

Date format

SunilChauhan — Tue, 30 Aug 2011 13:08:32 GMT

i believe only upper can be used

upper(datefieldname)

Date format

Tue, 30 Aug 2011 13:19:05 GMT

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?

Date format

SunilChauhan — Tue, 30 Aug 2011 13:28:45 GMT

while fetching in script

upper(datefieldname) as datefieldname

Date format

Tue, 30 Aug 2011 13:36:24 GMT

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.

Date format

swuehl — Tue, 30 Aug 2011 14:08:12 GMT

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?