Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matancha
Creator
Creator

Add minutes(int) to DATE

Hi All

I'm new to QlikView, and I've searched for a similar post to my query but am unable to find one. This a simple question so hopefully someone can help...

I have field call CURDATE that hold the number of the minutes from 01.01.1988. (ex: 11409102, 11964960)

How I can get a current DATE (DDMMYYY hh:mm) - from this?

Thks.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use This formula:

=Date((MinutesField/(60*24))+32143,'DD-MM-YYYY hh:mm')

Hope this helps you.

Regards, tresesco





View solution in original post

5 Replies
Not applicable

Date(Date1,'DD/MM/YYYY hh:mm')

tresesco
MVP
MVP

Use This formula:

=Date((MinutesField/(60*24))+32143,'DD-MM-YYYY hh:mm')

Hope this helps you.

Regards, tresesco





matancha
Creator
Creator
Author

Thanks for your quick answer!

it's works.

matancha
Creator
Creator
Author

Hi.

I had the script:

Aline:



SQL SELECT
PART,
CURDATE
FROM ZZZ.dbo.ALINE;

and I want to post on edit script, at SQL select statment (somthing like this):

SQL SELECT PART, CURDATE,

Date((CURDATE/(60*24))+32143,'DD-MM-YYYY hh:mm') as "Aline_Curdate",
Year(Aline_Curdate) as "Aline_Year_Curdate",
Month(Aline_Curdate) as "Aline_Month_Curdate",
Day(Aline_Curdate) as "Aline_Day_Curdate"

from .....

How can I do this?

Tnks.

tresesco
MVP
MVP

Hi,

use your script with LOAD rather than in SQL SELECT. I mean once it is fetched from the base database using SQL SELECT you should use LOAD command to allow QV work upon it so that all QV specific commands are supported.