12-16-2013 03:07 AM
I have a requirement were as to create a new view between 2 dates for fields open.time.
Opened before field: shoud take the value tod() but in the format eg 16/12/13 00:00:00
Open by filed : shoud take the value tod() but in the format eg 16/12/13 00:00:00- 7 00:00:00
Can someone guide me to write thh normalized query for the same ...
Solved! Go to Solution.
12-16-2013 03:18 AM
before implementing that i have to tell you that any such operations in query of view make a big load on system and might afffect the speed.
16/12/13 00:00:00 can be achieved by date(tod())
16/12/13 00:00:00- 7 00:00:00 can be achieved by date(tod())-'7 00:00:00'
I have not tested it in my environment but we have previously done such queries.
12-16-2013 03:22 AM
Thanks for the response ... However if I use tod() it takes the format as current time and current date .. I need the format as current date and time as 00:00:00.
Yes , I am aware of the implication, I will be testing the same in my test environment..
12-16-2013 03:29 AM
if you will look at the expression which i posted, you will see that I am not using direclty tod() but date(tod()).
In this case date() operator is taking the date from current time and adds 00:00:00 to it.
12-16-2013 04:58 AM