Skip to Content
avatar image
Former Member

Between Date

Hi experts,

I have Two dates X and Y and i need difference between two dates as YYYYWW format.Here i am facing an issue while using Daysbetween(X;Y) when 01/01/2017 as it was week-52 as per ISO standards but in my report i was getting it as Week-01 which is giving wrong results.please help me to resolve

Thanks in Advance

Regards,

vinay G

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Mar 01, 2017 at 02:39 PM

    No for 01/01/2017 week number is 52. how are you getting week 1?

    what is your calculaiton?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01, 2017 at 06:03 PM

    Hi man.

    I would like to know something like that.

    But In my case the final Result would be able to show in hours.

    Something like that:

    Finish Date : 01/03/2017

    Hour Finish Date : 10:30

    Start Date : 28/02/2017

    Hour Start Date : 08:00

    If you know the exactly time is: (Finish Date + Hour Finish Date) - (Start Date + Hour Start Date).

    The time is: 26 Hours , 30 Minutes.

    But. How can I do these in Hana?

    Thanks you all.

    Add comment
    10|10000 characters needed characters exceeded