September 26, 200421 yr Hi, I'm purchased a calendar solution which I've been changing to reflect the UK date format (day/month/year). The only problem is in various scripts which navigate to a certain selected month. As part of these scripts, the selected year is inserted into the Day_1 field: Insert Calculated Result [ Calendar::Day_1; Calendar::Go_Year ] but what happens then is that for some strange reason it also inserts :00:00 at the end of the date so the result is Day/Month/Year:00:00, which of course is not accepted by the field validation and stalls the script. I can't see why this is inserted into the field as the Go_Year field is just a global text field. Can anyone help? Thanks
September 26, 200421 yr There's no need for Insert Calculated Result here. Try using a Set Field instead. Do you get the same result?
September 26, 200421 yr the selected year is inserted into the Day_1 field: Insert Calculated Result [ Calendar::Day_1; Calendar::Go_Year ] I can't see how this would work if your Day_1 field is a date field ?
September 27, 200421 yr Author hi, Thanks for replying. I sorted it out in the end by deleting that script step and adding the required data to a previous script. Oh well, it's all an education. Thanks again.
Create an account or sign in to comment