So, How can I write an Expression in the Derived Column to change the Date from last six days? Without Changing the 'TimeReading' that is side to the Date.
That means the Date should change and pop up from previous 6 days and TimeReading next to the Date should be same as previous data.
What I did:
In the Expression, if I give GETDATE() output is populating with today's date and the TimeReading is populating with 00:00:00.
If I give GETDATE()-1, output is populating with the previous date and TimeReading is populating with 00:00:00,
But I need to get the continuous date from the last six days with the same TimeReading.
Can anyone help?