07-26-2017 12:01 PM
hello, i made a code to read data from table using time stamp duration but the problem is that i am unable to read the desired result using time duration
For example: 2 hour on the date 25/07/2017 from the table
but i was unable to read it,the reason i found was that the time stamp i was getting to compare within the duration i have selected was not correct.
if anyone of you would sort it out that would be really grateful,thanks
Solved! Go to Solution.
07-26-2017 12:44 PM
Check your string that you make when you concatenate the date with the time, it looks like "25-07-201710:58". You need to add a space so it looks like this "25-07-2017 10:58".
When you scan from string, your time is not exactly in the %T format, so you have to specify what your time looks like. Your format string will look something like this "%<%d-%m-%Y %H:%M>T".