1 of 1 people found this helpful
You've referenced the field [TO_CHAR(B.LDATE)] in your calculation but you aren't showing it in the preview of the data. Are we to assume that [TO_CHAR(B.LDATE)] matches the LDATE column you're showing in the preview?
If so, then I can see why the formula would be invalid. Take the first example;
Your dateparse would effectively be trying to parse 2016080501. That doesn't seem right to me?
Sorry I changed To_Char(Ldate) to Ldate. But I had older screenshot that I upload. I will fix right now. Thanks
Thank you Tom, I fixed the issue and it is working. I just took +"1" from the dateparse.