Start and end time for all entry

[balrammahato204]

Hi all,

Please help me out

How can i fetch all the start time and end time for every Assignment history Entry.

for eg:-

  ID                  Assignment History                    Start Date                                                  End Date

001               Global-Service Desk               Feb 24, 2015 8:13:08 AM               Feb 25, 2015 6:55:20 AM

001               Application Support  1             Feb 25, 2015 6:55:20 AM               Mar 11, 2015 8:55:56 AM

ID	Assignment Date	Assignment Order	Assignment History
001	Feb 24, 2015 8:13:08 AM	1	Global-Service Desk
001	Feb 25, 2015 6:55:20 AM	2	Application Support  1
001	Mar 11, 2015 8:55:56 AM	3	Application Support  2
001	Mar 12, 2015 1:59:56 AM	4	Global-Service Desk-1
001	Mar 13, 2015 5:10:53 AM	5	Application Support  3
001	May 8, 2015 6:49:54 AM	6	Application Support  1

Regards

Balram

[johanlindell]

Hi,

I think this is what you want. Load the table again into a new table and "peek" the date-field to get the previuos row's start date.

[balrammahato204]

Hi Johan,

Thanks for your solution but in my last entry of "End date", I am getting the null value in place of "End date" (i want the same value which is as start date.)

[johanlindell · Accepted solution]

Just modify the [End date] syntax (attached) to make an exception for the first row. You could also use "Now()" as the last timestamp. Also in the code but commented out.