Forum Discussion
Calculate difference in minutes
I wanna know from the Datestamp coulmn see how much minute difference it's between the previous value and the last one. I tried this formula below but got totaly different value. Datediff = DAT...
hnguy71
Super User
Super Userit shouldn't matter. My original source for the date is exactly the same as yours. I'll upload the sample file for you to view:
https://1drv.ms/u/s!An8CCFsOzw0uc_OWSjBbUOCOgPk
now it works after small changes, thanks but is that possible that it gonna only filter from 10 May and after? where in the code can I write it and how? because the data are huge and it's says ,
There's not enough memory to complete this operation. Please try again later when there may be more memory available.
- hnguy71
If you're importing your data, you can filter from May 10th onwards. If you're using LiveConnection or from a database you can specify the filter ie,
SELECT * FROM db.MyDatabase WHERE CommTimeStamp >= '10/05/2019'
Can I use another instead for EARLIER? because it's earler that cause this memory problem. or do you have anyother soulation?