topic Re: easy and tricky? in QlikView

easy and tricky?

Anonymous — Thu, 29 Jan 2015 10:25:07 GMT

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 ?

Re: easy and tricky?

its_anandrjs — Thu, 29 Jan 2015 10:37:38 GMT

Hi,

Try with convert to NUM and then in date format.

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

Regards

Anand

Re: easy and tricky?

crusader_ — Thu, 29 Jan 2015 10:39:34 GMT

Hi,

Try this expression:

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

hope this helps

Regards,

Andrei Kaliahin

Re: easy and tricky?

PrashantSangle — Thu, 29 Jan 2015 10:39:38 GMT

Hi,

Use Floor()

Try like

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

Regards

Re: easy and tricky?

Anonymous — Thu, 29 Jan 2015 11:01:18 GMT

DID NOT WORKED ALL

Re: easy and tricky?

engishfaque — Thu, 29 Jan 2015 11:22:33 GMT

Dear Commonqlik,

Try this one,

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

period

41,938

52,656

];

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

Re: easy and tricky?

Frank_Hartmann — Thu, 29 Jan 2015 11:22:43 GMT

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

Re: easy and tricky?

andrespa — Thu, 29 Jan 2015 11:25:01 GMT

Hi,

Try this:

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

Hope it helps.

Andrés

Re: easy and tricky?

Anonymous — Thu, 29 Jan 2015 11:59:01 GMT

Hi,

Try:

Data:

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

Re: easy and tricky?

Gabriel — Thu, 29 Jan 2015 12:32:37 GMT

Hi,

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

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