Problem with '=TODAY' formule in sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2234634%22%20slang%3D%22en-US%22%3EProblem%20with%20'%3DTODAY'%20formule%20in%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2234634%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20with%20my%20Sharepoint%20List%20which%20is%20not%20working%20correctly%20as%20it%20did%20before.%3C%2FP%3E%3CP%3EMS%20changed%20something%20with%20calculated%20columns%20and%20now%20my%20Sharepoint%20List%20and%20Flow%20doesn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20the%20list%20with%20the%20Holidays%20schedule.%20Employees%20have%20to%20select%20start%20and%20end%20date.%3C%2FP%3E%3CP%3EThe%20date%20before%20was%20automatically%20set%20to%3A%3C%2FP%3E%3CP%3EStart%20date%3A%20Today%2C%2000%3A00%3CBR%20%2F%3EEnd%20date%3A%20Today%2C%2023%3A59%3C%2FP%3E%3CP%3EEnd%20date%20was%20set%20by%20the%20formula%20'%3CSPAN%3E%3DToday%2B1%2B(1%2F24%2F60*1439)'%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENow%20that%20does%20not%20work%20and%20the%20End%20Date%20is%20set%20to%2000%3A00%20which%20is%20wrong%20and%20breaks%20down%20my%20Flow%20by%20saying%20%22Your%20request%20can't%20be%20completed.%20The%20duration%20of%20an%20event%20marked%20as%20All%20day%20must%20be%20at%20least%2024%20hours.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECould%20you%20please%20tell%20me%20what%20should%20I%20do%20to%20set%20the%20end%20date%20automatically%20to%20%22Today%2C%2023%3A59%22%3F%20Now%20it%20looks%20like%20that%20and%20I%20need%20the%20%22Data%20zako%C5%84czenia%22%20to%20be%20always%20set%20as%2023%3A59.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EtaBir_0-1616663447347.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266934i16F6523639EFBF66%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EtaBir_0-1616663447347.png%22%20alt%3D%22EtaBir_0-1616663447347.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3EEtaBir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2234634%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello guys,

 

I have a problem with my Sharepoint List which is not working correctly as it did before.

MS changed something with calculated columns and now my Sharepoint List and Flow doesn't work.

 

I created the list with the Holidays schedule. Employees have to select start and end date.

The date before was automatically set to:

Start date: Today, 00:00
End date: Today, 23:59

End date was set by the formula '=Today+1+(1/24/60*1439)'

 

Now that does not work and the End Date is set to 00:00 which is wrong and breaks down my Flow by saying "Your request can't be completed. The duration of an event marked as All day must be at least 24 hours."

 

Could you please tell me what should I do to set the end date automatically to "Today, 23:59"? Now it looks like that and I need the "Data zakończenia" to be always set as 23:59.

 

EtaBir_0-1616663447347.png

 

Kind regards

EtaBir

0 Replies