How can we write a script like Set analysis for below scenario?

Tue, 02 Oct 2012 13:01:17 GMT

Hi all ,

I have a issue.

I have two table like

1. StartTime

2. EndTime

Here, Now if I select the 2:36:07 AM from Endtime means Possible value for starttime is 2:36:07 AM.

But, I want to like below :

If I select the 2:36:07 AM from Endtime means Possible value for starttime is 2:36:05.

Likewise I need this 2:36:08 -----> 2:36:07.

Thanks In advance.

Regards,

Kabilan K.

Re: How can we write a script like Set analysis for below scenario?

MayilVahanan — Tue, 02 Oct 2012 13:16:45 GMT

Try like this

= time(time('2:36:05 AM')-1/(3600*60)) gives 2:36:04 AM

so, try like this time(time(yourField)-1/(3600*60)) as starttime

Hope it helps