Date problem

[#1]

Hye I have a question,

I have a file with, on it all the tables of my furm. each night, the tables are updated. This update is resumed in a file on QV.

My question is this :

All the tables are updated one after an other. So the information I have is the date of the end of the update(day/month/year houre/min/sec) of each table. like this :

I want to be able to have the time needed to update each table something like Date1 - Date2= time of update. does someone know a function I could use to do this?

Thx a lot for your help.

Raphael

[robert_mika]

Does this help?

t1:

LOAD

[nom table],

[upload creation date],

[upload creation date]-Peek( [upload creation date]) as Value1

FROM

(biff, embedded labels, table is Sheet1$);

[#3]

Yes it works but still a problem, in my file the creation dates aren't originaly sorted from newest to odlest. So when I sort my datas by the creation date the expression doesn't work and I get empty cases :

Thank you so much for your help robert!

[robert_mika · Accepted solution]

Could you send the "real" data?

not sorted.

In meantime try this:

t1:

LOAD

[nom table],

[upload creation date],

[upload creation date]-Peek( [upload creation date]) as Value1

FROM

(biff, embedded labels, table is Sheet1$);

t2:

LOAD

[nom table] as Table,

[upload creation date] as Date,

Value1 as Time

resident t1

Order by [upload creation date]asc

;

drop table t1

Feeling Qlikngry?

How To /Missing Manual(17 articles)

[#5]

Ok I succeded!!

Thx for your preacious help!

[robert_mika]

Great.

Could you mark any of the posts as Answered/Helpful to close the topic,please?