Calculating The Time

Help Activities
1

Hi,

I have to calculate whether if it is One Hour Above or not…!!

For reference I attached the screenshot below.

Thanks,
Rishi

IMG_20211216_111549
IMG_20211216_1115491846×4000 1.42 MB

2

Hey

Check out this post from @ppr

You can compare time using CDate.

Hopefully this help.

3

Hi @Rishik_Chowdary,

Use below query.
dt.Select("Duration not like '00%'").CopyToDataTable()

Regards,
Arivu