I have a string date in the UK format "DD/MM/YYYY" when I insert this into a sharepoint date column it gets parsed as "MM/DD/YYYY".
So when I insert "01/02/1990" (1st Feb 1990) it gets inserted as 2nd Jan 1990.
Is there a way to convert "DD/MM/YYYY" to a timestamp (YYYY-MM-DD) so that the date can be inserted correctly. ?
I have looked at the formatDateTime function but the first argument to that expects only YYYY-MM-DD ?
Hi!
You need to transcript your date into timestamp like that: 2020-06-19T17:26:02.1821723Z
So you need:
1. Use split expression and separate your date
2. Use concat
concat(split('DD/MM/YYYY','/')[2],'-',split('DD/MM/YYYY','/')[1],'-',split('DD/MM/YYYY','/')[0],'-00T00:00:00.0000000Z') Here u have timestamp 🙂
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2