Quote:
Originally Posted by BobBridges
Hm. What are the contents of L4? Since they form a part of the URL, maybe there's something invalid there?
|
I think it's right, but here's the whole chainlink of formulas.
L4 :
="&date_range_from="&L2&"&date_range_to="&L3&"&sco re_range_from=60&search_type=advanced"
L2 :
=CONCATENATE(MID(PC!C1,19,2);"-";MID(PC!C1,16,2);"-";RIGHT(PC!C1,4))
L3 :
=CONCATENATE(IF(LEN(((MID(PC!C1,19,2))+3))=1;0&((M ID(PC!C1,19,2))+3);((MID(PC!C1,19,2))+3));"-";MID(PC!C1,16,2);"-";RIGHT(PC!C1,4))
PC!C1 :
Last Updated : 31/09/2013