Skip to Content
0

Between Date

Mar 01, 2017 at 11:34 AM

28

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Mar 01, 2017 at 02:39 PM
0

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

what is your calculaiton?

Share
10 |10000 characters needed characters left characters exceeded
Cristopher Alexis Castillo Castillo Mar 01, 2017 at 06:03 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded