Android Question [SOLVED] Period not returning expected result.

[ProjectGroup19]

Dim  CurrentDate As Long =DateTime.Now
Log(CurrentDate): 1624961984591

Dim check As Long=DateUtils.SetDate("2021","06","30")
Log(check): 1625011200000

Dim  DateCheck As Period=DateUtils.PeriodBetweenInDays(CurrentDate,check)
Log(DateCheck): [Days=0, Hours=13, IsInitialized=true, Minutes=40, Months=0, Seconds=15, Years=0]

 

[agraham]

What is unexpected? 'Check' is set to 00:00 on the 30th June and 'DateCheck' is 13 hours from now which looks about right given we are at about midday on the 29th.

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

 

[ProjectGroup19]

Please use [code]code here...[/code] tags when posting code.

ok, noted...Thank you

 

[ProjectGroup19]

What is unexpected? 'Check' is set to 00:00 on the 30th June and 'DateCheck' is 13 hours from now which looks about right given we are at about midday on the 29th.

The number of days..It should be 1 not 0.

 

[agraham]

The number of days..It should be 1 not 0.

Why should it?

 

[Mahares]

The number of days..It should be 1 not 0.

Dim CurrentDate As Long =DateTime.Now  'uses the current time component

Dim check As Long=DateUtils.SetDate("2021","06","30") 'uses midnight as time component.

The answer is correct

 

[ProjectGroup19]

Why should it?

Because, the Current date is 29-06-2021 and the Check date is 30-06-2021
the Days difference should be 1 or?

 

[ProjectGroup19]

Dim check As Long=DateUtils.SetDate("2021","06","30") 'uses midnight as time component.

The answer is correct

Midnight as time component??

i don't understand. Please, help me to.

 

[Mahares]

Midnight as time component??

When you start typing DateUtils.SetDate( you will see in the intellisense that it tells you the time will be 00:00:00
You were not comparing the 2 dates with respect to the same exact time slot of the day.
DateTime.Now means more than today. It means today plus the time you took the reading which changes every second

 

[ProjectGroup19]

When you start typing DateUtils.SetDate( you will see in the intellisense that it tells you the time will be 00:00:00
You were not comparing the 2 dates with respect to the same exact time slot of the day.

Ohk, i get you now. it's assumed that a new day has started due to the time part 00:00:00.
Thank you very much

 

[Mahares]

the Days difference should be 1 or?

If you want the difference to be 1, you can do this:, by excluding the time component from today's date

Dim CurrentDate As Long =DateTime.DateParse(DateTime.Date(DateTime.Now))

 

[ProjectGroup19]

If you want the difference to be 1, you can do this:, by excluding the time component from today's date

Dim CurrentDate As Long =DateTime.DateParse(DateTime.Date(DateTime.Now))

This worked as expected

Dim check As Long=DateUtils.SetDateAndTime("2021","06","30",23,59,0)

This is what i did earlier..It also worked as expected.