add 1 minute to date field

[Anonymous]

Hi all

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

I need to add 1 minute to datetime?

thanks

[christophebrault]

Hi,

can you try this ?

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

[masha-ecraft]

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]

Hi,

     Check with this

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

Celambarasan

[SunilChauhan]

USE  BELOW CODE

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

HOPE THIS HELPS

[jagan]

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.