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: 
Anonymous
Not applicable

add 1 minute to date field

Hi all

I have a date field - DATETIME formatted DD/MM/YYYY HH:MM

I need to add 1 minute to datetime?

thanks

5 Replies
christophebrault
Specialist
Specialist

Hi,

can you try this ?

=date(DATETIME+maketime(0,1,0),'DD/MM/YYYY HH:MM')

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
masha-ecraft
Partner - Creator
Partner - Creator

Since the internal representation of datetime in QV is a number with the part before decimal point representing number of days, the expression you should add to your field should be 1/(24*60).

/Masha

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

     TimeStamp(Num(DateField)+(1/(24 * 60)),'DD/MM/YYYY HH:MM')

Celambarasan

SunilChauhan
Champion
Champion

USE  BELOW CODE

TIMESTAMP(TIMESTAMP(TIMEFIELDNAME) +MAKETIME(00,01,00))

HOPE THIS HELPS

Sunil Chauhan
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this example

=TimeStamp(Num(Date#('04-24-2012 08:00', 'MM-DD-YYYY hh:mm'))+(1/(24 * 60)),'DD/MM/YYYY HH:mm')

Hope this helps you.

Regards,

Jagan.