Hello all,
I need some help calculating the number of days between two dates. I'm working with the AS400 so all of our dates are formated as YYYMMDD, like today's date would be 1040810. I have two dates I'm using that were originally formatted like this - I can reformat them to appear as DD/MM/YYYY, which I've done, and then I tried to use the "Days Between" function, but it tells me I'm using the wrong data types. Is there another way to calculate the days between two dates? Or, if not, how can I format my dates correctly so Business Objects will accept them?
Thanks!
I need some help calculating the number of days between two dates. I'm working with the AS400 so all of our dates are formated as YYYMMDD, like today's date would be 1040810. I have two dates I'm using that were originally formatted like this - I can reformat them to appear as DD/MM/YYYY, which I've done, and then I tried to use the "Days Between" function, but it tells me I'm using the wrong data types. Is there another way to calculate the days between two dates? Or, if not, how can I format my dates correctly so Business Objects will accept them?
Thanks!