Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a button through which i am selecting the range of values.The field that i am selecting is in the format dd/mm/yyyy hh.
='>=' & TIMESTAMP(TIMESTAMP#(LEFT(TIMESTAMP(VSHIFTSTARTREPORT,'DD/MM/YYYY hh'),13),'DD/MM/YYYY hh'),'DD/MM/YYYY hh') & '<' &
TIMESTAMP(TIMESTAMP#(LEFT(TIMESTAMP(TIMESTAMP(TIMESTAMP#(LEFT(TIMESTAMP(VSHIFTSTARTREPORT,'DD/MM/YYYY hh'),13),'DD/MM/YYYY hh'),'DD/MM/YYYY hh')+(VSHIFTHOURSREPORT/24),'DD/MM/YYYY hh'),13),'DD/MM/YYYY hh'),'DD/MM/YYYY hh')
but when i use the same formula to select the range of values it doesn't work.
If i do it individually like below it works.Not sure what is going wrong.
works: the below selection in the button works but when these two are combined it doesn't select the range of values.
TIMESTAMP(TIMESTAMP#(LEFT(TIMESTAMP(VSHIFTSTARTREPORT,'DD/MM/YYYY hh'),13),'DD/MM/YYYY hh'),'DD/MM/YYYY hh')
or
TIMESTAMP(TIMESTAMP#(LEFT(TIMESTAMP(TIMESTAMP(TIMESTAMP#(LEFT(TIMESTAMP(VSHIFTSTARTREPORT,'DD/MM/YYYY hh'),13),'DD/MM/YYYY hh'),'DD/MM/YYYY hh')+(VSHIFTHOURSREPORT/24),'DD/MM/YYYY hh'),13),'DD/MM/YYYY hh'),'DD/MM/YYYY hh')
Any suggestions are much appreciated.
Thanks in advance.
Is your field (on which you are putting this trigger on) correctly read as timestamp field?
Hi Sunny,
thanks for reply., yes it is read as time stamp..
thanks
if I test it individually like I mentioned above it works so
the field is actually a time stamp but for some reason it is
not picking the >= and < condition. To get the range of values