Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a date field - DATETIME formatted DD/MM/YYYY HH:MM
I need to add 1 minute to datetime?
thanks
Hi,
can you try this ?
=date(DATETIME+maketime(0,1,0),'DD/MM/YYYY HH:MM')
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
Hi,
Check with this
TimeStamp(Num(DateField)+(1/(24 * 60)),'DD/MM/YYYY HH:MM')
Celambarasan
USE BELOW CODE
TIMESTAMP(TIMESTAMP(TIMEFIELDNAME) +MAKETIME(00,01,00))
HOPE THIS HELPS
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.