topic Add second in date in QlikView

Add second in date

Wed, 05 May 2010 13:26:24 GMT

Hello,

I want add a second in a date time like SQL function:

DateAdd(second, -1, u.dat1erdepot) And DateAdd(second, 1, u.dat1erdepot)

you have an idea because in Qlikview I see addmonth and addYear but not addsecond.

Thank you [:)]

Add second in date

Wed, 05 May 2010 15:29:47 GMT

I believe there is no function because QlikView allows simple math on dates. Date + 1 adds one day to the date. If the day is a whole number, then adding a second means adding the proper fraction of one day. One second is 1/86400 days. Therefore:

Date + (1/86400)

Should add one second to your date.

Add second in date

Wed, 05 May 2010 16:08:55 GMT

Thank you and if is a date time?

Add second in date

Wed, 05 May 2010 16:11:15 GMT

Datetime should work the same. A date is just a whole number (today is 40303). A datetime is the same number, but includes decimal place for the time (right now is 40303.424....). Either way, it will add 1/86400 of a day, which is one second.

Add second in date

Wed, 05 May 2010 16:20:10 GMT

Thank you very much 🙂

I have another problem I have post a new topic you can help me too ? it's LOAD and RESIDENT 🙂