Formatting Dates

[swatiras]

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

[vinieme12]

try below

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

[Anonymous]

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.

[tresesco]

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.

[its_anandrjs]

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

[sunny_talwar]

What format do you have for your environmental variables?

Change this to

SET DateFormat='DD-MMM-YYYY';