Subtract minutes
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am
Subtract minutes
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
ds_search2008, 0.5 hours and 5 minutes are not the same thing.
Investigate the time conversion functions with "Since" in their names.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am