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.
