How to substract a second (or a minute) from a date field?!?

[hansdevr]

I need to fill a new field in a table with the date from a field in a previous record.

The latter contains a date in the following format: yyyy-mm-dd hh:mm:ss:xxxxxxx (not sure what those xx's are). Example:

2014-11-14 02:00:50:3930000

I need to use that value in a (new) field in the current record, but I need to substract a second or a minute from that value.

I have been searching, but couldn't find an answer...

[#2]

Hi,

How to calculate the time difference between two different date?

Use the above link, it might help u.

[sunny_talwar]

Not sure what you mean when you say you have to subtract a second or a minute? In your above example: 2014-11-14 02:00:50:3930000 what would be the output you would be expecting?

[#4]

Hi,

it might help you.

Subtract two timestamps to output difference in minutes

[hansdevr]

Hi Harshita and thank you for your swift reply.

I have looked at that link, and unfortunately, it gives an example on how to calculate a difference, not how to substract a value (of a second or a minute).

Thanks anyway!

[hansdevr]

If the first value is 2014-11-14 02:22:50:3930000 then the second value should be 2014-11-14 02:22:49:3930000

(which subtracts one second) OR the outcome should be 2014-11-14 02:21:50 3930000, which is the subtraction of a minute.

[sunny_talwar]

I think you need to create a master Time Table: The Master Time Table

This works as a master calendar, where you create missing time values. You can decide your smallest denomination to be Seconds or Minute.

HTH

Best,

Sunny

[hansdevr]

Actually, I want to do the subtraction using a variable.. It's not a matter of a 'missing' time value - I just want to do a calculation on the value of a field within a record..

[#9]

First set up format like

for Minutes Calculation

vNowTime= num(timestamp#('2015/09/07  11:55:25 PM','YYYY/MM/DD  hh:mm:ss TT'));
vPrevTime = num(timestamp#('2015/09/07  11:55:25 PM','YYYY/MM/DD  hh:mm:ss TT'));

sum(vNowTime - vPrevTime )

or

vNowTime= num(timestamp#(INVTIME,'YYYY/MM/DD  hh:mm:ss TT'));

vPrevTime = num(timestamp#(INVTIME,'YYYY/MM/DD  hh:mm:ss TT'));

for Days Calculation

sum(Date(Today())- date(date#(INVDATE,'YYYYMMDD'),'DD/MM/YYYY'))

hope it works

[hansdevr]

A bit like AddMonths(EndDate,-1), but then for a minute or a second, if you catch my drift..