Copy a date while editing item

%3CLINGO-SUB%20id%3D%22lingo-sub-1889889%22%20slang%3D%22en-US%22%3ECopy%20a%20date%20while%20editing%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1889889%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*edit*%20People%20don't%20work%207%20days%2C%20so%20some%20days%20will%20be%20empty.%20I'm%20thinkin'%20of%20a%20%22IF%22%20formula%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIs%20there%20a%20formula%2C%20that%20can%20copy%20the%20date%20that%20is%20in%20the%20previous%20column%20while%20the%20item%20is%20edited%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EF.E.%3A%20Employees%20must%20fill%20in%20the%20starting%20date%20and%20time%2C%20and%20the%20end%20date%20and%20time%20(sometimes%20the%20work%20exceed%20the%2000%3A00%20time)%2C%20but%20most%20of%20the%20work%20is%20done%20on%20the%20same%20day.%20So%2C%20it%20would%20be%20very%20handy%20to%20copy%20the%20date%20field%20(not%20the%20time!)%20in%20the%20next%20column%2C%20while%20keeping%20the%20Date%2FTime%20format%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMonday%20Start%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B16-11-2020%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2008%3A00%3C%2FP%3E%3CP%3EMonday%20End%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*copy%20date%20here*%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B16%3A00%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%2C%20in%20advance.%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ERoel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1889889%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi!

 

*edit* People don't work 7 days, so some days will be empty. I'm thinkin' of a "IF" formula?


Is there a formula, that can copy the date that is in the previous column while the item is edited?


F.E.: Employees must fill in the starting date and time, and the end date and time (sometimes the work exceed the 00:00 time), but most of the work is done on the same day. So, it would be very handy to copy the date field (not the time!) in the next column, while keeping the Date/Time format

 

Monday Start     16-11-2020            08:00

Monday End     *copy date here*     16:00

 

Thank you so much, in advance.

Regards

Roel

0 Replies