Forum Discussion
Solved
Format Date which is a string / Using a View
Hello, I have a Date column which is a String . I would like to generate a new column, that shows me the last n days. Therefore I need to convert my Column in a date Im using this code: Colu...
Use SUBSTITUTE to replace your "." with "/" before you try DATEVALUE.
Maybe I should mention that my text date looks like this: DD.MM.YYYY
Hi,
There could be one of 2 problems. Either . is not a recognised date seperator in your Windows Installation or if it is, then may be your systems date format in MM/DD/YYYY. It could also be both reasons.