Hi all, got two quick queries for you, hoping someone can help, much appreciated!
1. I have to do a date calculation on some old data like this:
(Today()-39) - Date[Datecalllogged] as [Name]
However at the moment the data isn't being updated what do I need to change so that the (today()-39) increases each day? So tomorrow its value is (Today()-40) how do you get it to update??
2. Once I've done this calculation I have the problem that Datecalllogged is in ddMMYYYY MMHHSSMM format and I only need the format in DDMMYYYY this means I end up with a Name value of 104.23244554 is there a way to get these calculations so I get a whole number instead? e.g. 104 straight away?
Hope that makes sense, thankyou all!
Ben