Subtract minutes

ds_search2008 · Post by **ds_search2008** » Thu Apr 09, 2009 5:34 am

Hello all,

I need to subract 5 minutes from a timestamp field. I tried the option

DateData1.TmStpFld - 0.5 hours

Where

DateData1 is the input link
TmStpFld is the Timestamp column

This is not working. I'm sure this is not correct. Could you please correct me and help me in this regard.

Many Thanks & Kind Regards

Aquilis · Post by **Aquilis** » Thu Apr 09, 2009 5:54 am

DateData1.TmStpFld[1,14]:(Right(DateData1.TmStpFld,5)-05:00)

ray.wurlod · Post by **ray.wurlod** » Thu Apr 09, 2009 7:31 am

Did you test that, Aquilis ?!!

ds_search2008, 0.5 hours and 5 minutes are not the same thing.

Investigate the time conversion functions with "Since" in their names.

Pravenai · Post by **Pravenai** » Thu Apr 09, 2009 7:37 am

Hi,

You can try this function
timestampfromsecondssince(-300,<column with timestamp value>)

ray.wurlod · Post by **ray.wurlod** » Thu Apr 09, 2009 9:26 am

Teaching someone to fish is always better than giving them a fish.

Aquilis · Post by **Aquilis** » Thu Apr 09, 2009 12:35 pm

My Bad,
you can go with Sincefunctions Or with
DateData1.TmStpFld [1,14]

(Right(DateData1.TmStpFld,5)[1,2])-05):':':Right(DSLink16.Out,2)

chulett · Post by **chulett** » Thu Apr 09, 2009 2:10 pm

Why so sad?

ds_search2008 · Post by **ds_search2008** » Mon Apr 13, 2009 8:31 am

Dear experts,

Thanks a lot for all your replies and time. I will try this out. Many thanks and sorry for my late response.

Kind Regards.

ds_search2008 · Post by **ds_search2008** » Mon Apr 13, 2009 12:36 pm

Great!!!! Its working fine. Thank you all. Thanks a lot. :D

Kind Regards