topic Re: Date function is working find on Text object but not at backend. in QlikView

Date function is working fine on Text object but not at backend.

ankitbisht01 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

There is a small issue i am facing ,while Adding few hours to my "CREATEDDATETIME" field .

I need to make a new field which will have few hours added to old field , for example i need to add 5:1/2 hours.

When i add them in Text Object and select a date it shows desired result , but when i put the expression at back end script , i get blank field.

Format of my "CREATEDDATETIME" field : '3/31/2010 9:09:24 AM '

Function i am using on text object : date(date(date#(CREATEDDATETIME,'MM/DD/YYYY hh:mm:ss tt'), 'MM/DD/YYYY hh:mm:ss tt')+ (330/24/60), 'MM/DD/YYYY hh:mm:ss tt').(this is working fine when i select any date from the filed shows me the right result regarding that date.)

Using same at Back end: date(date(date#(CREATEDDATETIME,'MM/DD/YYYY hh:mm:ss tt'), 'MM/DD/YYYY hh:mm:ss tt')+ (330/24/60), 'MM/DD/YYYY hh:mm:ss tt') as newdate

Best Regards

Ankit

Re: Date function is working find on Text object but not at backend.

nagarjuna_kotha — Thu, 29 Sep 2016 07:20:20 GMT

I have checked data in my app by using this code.

May be like this ?

Sample:

LOAD

date(date(date#(Date,'MM/DD/YYYY hh:mm:ss tt'), 'MM/DD/YYYY hh:mm:ss tt')+ (330/24/60), 'MM/DD/YYYY hh:mm:ss tt') as New

INLINE [

Date

3/31/2010 9:09:24 AM

];

I hope this may help

Re: Date function is working find on Text object but not at backend.

nagarjuna_kotha — Thu, 29 Sep 2016 07:22:30 GMT

Output i m getting in the front end is :

03/31/2010 2:39:24 pm

Is this correct ?

-Nagarjun

Re: Date function is working find on Text object but not at backend.

CELAMBARASAN — Thu, 29 Sep 2016 07:27:13 GMT

Can you share some sample file, to figure out the issue.

Its working in my script, check the attachment.

Re: Date function is working find on Text object but not at backend.

manish_kumar — Thu, 29 Sep 2016 07:29:21 GMT

Hi Ankit

Please use this, it might help

Timestamp(CREATEDDATETIME+Interval('5:30','mm:ss')) as NewDate

Re: Date function is working find on Text object but not at backend.

ankitbisht01 — Thu, 29 Sep 2016 07:49:51 GMT

this function is working with the inline table or sample table if i create any , but not with my field . sharing the screenshots of Scripting and front end results.

Re: Date function is working find on Text object but not at backend.

ankitbisht01 — Thu, 29 Sep 2016 08:57:12 GMT

Yes and i am using the same script, as told before but not working on backend , however works find with text object

Re: Date function is working find on Text object but not at backend.

ankitbisht01 — Thu, 29 Sep 2016 08:59:50 GMT

Thank you for your responses people, Anyhow got the solution from one of my friend. And it works like this with my script .

-- Timestamp(CREATEDDATETIME+Interval('5:30','mm:ss')) as NewDate