INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Mathematical operations with dates  (Read 1982 times)

kroser8

  • Recent member
  • *
  • Posts: 20
Mathematical operations with dates
« on: November 01, 2015, 09:05:53 am »
Friends , I can not add the date to the number using the operator "math" (Expression Language):

I have the following formula :
formatdate([last played,0], ElapsedAgo)
And result:
56,8 days ago

We must add to it the number 2 to get 58,8. or 58.8
Logged

blgentry

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 8014
Re: Mathematical operations with dates
« Reply #1 on: November 01, 2015, 09:13:58 am »
I'm pretty sure you can get what you want by doing the math inside out:

formatdate(math( [last played,0] - 2), ElapsedAgo)

Brian.
Logged

kroser8

  • Recent member
  • *
  • Posts: 20
Re: Mathematical operations with dates
« Reply #2 on: November 01, 2015, 09:19:32 am »
Quote from: blgentry on November 01, 2015, 09:13:58 am
I'm pretty sure you can get what you want by doing the math inside out:

formatdate(math( [last played,0] - 2), ElapsedAgo)

Brian.

Return the empty result.((
Logged

kroser8

  • Recent member
  • *
  • Posts: 20
Re: Mathematical operations with dates
« Reply #3 on: November 02, 2015, 10:41:05 pm »
math(replace(Field(&&, 1), /,, .) - [&#] - [Number Plays] ^ 0.5)   

&&=RemoveRight(FormatDate([Last Played,0], Elapsed), 5)

Ohh.. It could not be easier to make ..
Logged
Pages: [1]   Go Up
« previous next »