How to compare the date and Time and need to get as updated time

Hi Friends,

I need to compare the date , which one is updated for example I had completed the work on today morning at 18/02/2020 9.30 a.m and again i started the work at 18/02/202013.00 pm and i need to compare both date and time , which one is update and i need to get output as 18/02/202013.00 pm is the updated one.

@saneeth_kandukuri How are you Storing those values?

1 Like

Hi @saneeth_kandukuri,

Assign updatedDateTime= IF(time2>time1,time2,time1)

Thanks,

2 Likes

Could you please help me,
DateTime.Parse(“2020-02-17 20:28:10”).ToString(“MM/dd/yyyy hh:mm:ss”)
While I using this I was getting output as 2/17/2020 08:28:10 but I need to get output as : 2/17/2020 20:28:10

Hi @saneeth_kandukuri

Use HH instead of hh

DateTime.Parse(“2020-02-17 20:28:10”).ToString(“MM/dd/yyyy HH:mm:ss”)

Thanks

1 Like

THANK YOU FOR KINDLY REPLY.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.