topic Re: Formatting Dates in QlikView

Formatting Dates

swatiras — Wed, 23 Aug 2017 06:06:04 GMT

Hi ,

I am using below function to format date :

Date(MY_DATE,'DD-MMM-YYYY') AS MY_DATE

I store this in a qvd

When i load the qvd , and put this date column in a table box , the format appears as :

M/DD/YYYY 12:00:00 AM

Please help

Re: Formatting Dates

vinieme12 — Wed, 23 Aug 2017 09:17:54 GMT

try below

Date(FLOOR(MY_DATE),'DD-MMM-YYYY') AS MY_DATE

Re: Formatting Dates

Anonymous — Wed, 23 Aug 2017 09:22:30 GMT

You can change the format settings under 'Number' tab in the properties of the table box at front end, though it showed in different format. please try to change.

Re: Formatting Dates

tresB — Wed, 23 Aug 2017 09:23:42 GMT

QVD probably doesn't store the formatting information. (I think, I read somewhere in this community, and never tested myself being that lazy..). You could perhaps, use the formatting when it is actually being used in the script around the variable.

Re: Formatting Dates

its_anandrjs — Wed, 23 Aug 2017 09:27:18 GMT

Can you share your sample app with limited loads to have a look for the solution.

Re: Formatting Dates

sunny_talwar — Wed, 23 Aug 2017 12:07:46 GMT

What format do you have for your environmental variables?

Change this to

SET DateFormat='DD-MMM-YYYY';