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 ...
Go to Solution.
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.
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..
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.
All works fine .. Thank you so much .. Greatly Appreciated ..