Tramle Posted August 6 Share Posted August 6 Hi Can i get a help with below Date subtraction issue :( My data have transaction date need to compare with another events time So i want to use Date([Transaction time]) - one day Ex : in excel I can use =2024/08/05 - 1 -->2024/08/04 But when I use this on spotfire, the result is #error Link to comment Share on other sites More sharing options...
Solution Olivier Keugue Tadaa Posted August 6 Solution Share Posted August 6 (edited) Hi Tramle use this expression DateAdd("day",-1,[Transaction time]) Edited August 6 by Olivier Keugue Tadaa 1 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now