easy and tricky?

[Anonymous]

i have a period field which contains

period:

41,938

52,656

i want convert it to date format like MM/DD/YYYY?

date(period,'MM/DD/YYYY) AS NEW   its working but showing in front end like

for example :

01/01/2015 12:00:00     here i dont want see the time here?

and i dont want to remove  through number tab  option ? because every time i have chnage when i pull into front end ?

[its_anandrjs · Accepted solution]

Hi,

Try with convert to NUM and then in date format.

Date( Num(period), 'MM/DD/YYYY') as NEW

Regards

Anand

[crusader_]

Hi,

Try this expression:

date(floor(period),'MM/DD/YYYY') as NEW

hope this helps

Regards,

Andrei Kaliahin

[PrashantSangle]

Hi,

Use Floor()

Try like

Date(floor(period),'MM/DD/YYYY') AS NEW

Regards

[Anonymous]

DID NOT WORKED ALL

[engishfaque]

Dear Commonqlik,

Try this one,

LOAD *, Date(num(period), 'DD/MM/YYYY') as newPeriod Inline [

period

41,938

52,656

];

or

Create a text object and use, if output is -1 it means date is coming in text form, then apply proper date functions.

If 0 or 1 is coming it means date is coming right from data source something is going wrong in script/expression level.

=IsText(newPeriod)

Kind regards,

Ishfaque Ahmed

[Frank_Hartmann]

left(date(period,'MM/DD/YYYY),10) AS NEW  

[andrespa]

Hi,

Try this:

date(left(period,'MM/DD/YYYY'),10) AS NEW

Hope it helps.

Andrés

[Anonymous]

Hi,

Try:

Data:

LOAD Date(num(period), 'MM/DD/YYYY') as period;
LOAD Purgechar( period, ',' ) AS period
from Table;

[Gabriel]

Hi,

Please read this blog (HIC has few blogs on Date)

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/18/number-format-codes