Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have the attached script, the period field is coming through ina text format, so i am trying to change it to a num format in the script (so it links to other data correctly) but when i do that it doesnt load any values for the field.
I have commented out lines 72-80 which does the NUM change so you can see the text format working.
Any chance someone could take a look to see what i am doing wrong please?
Try using trim() like:
Num(trim(Period)) as Period
In fact trim() alone should work, like :
trim(Period) as Period
nice one! thanks!