Forum Discussion
Solved
Replace Numbers with Date Sequencial
Hi, hoping someone can help my aim is to replace the numbers with the specified date after each date change.
Hi, thanks that works and easier much appreciated.
Regards Colin
Hi ColinCowan ,
My pleasure!
If it works, would you mind accept it as solution? Then more people who have the same requirment will find the solution quickly and benefit here, thank you!
Best Regards,
Community Support Team _ kalyj
Greg, I adde a custom column copy pasted the formula and ended up with this. Please rememer I am a complete novice.
ColinCowan I'll walk you through it.
- Get rid of that column you just added.
- Add Column tab in the ribbon, Custom Column
- Paste this into the formula area: try DateTime.FromText([Column1 - Copy]) otherwise null
- Click OK
- Right-click the header of your new column and choose Fill and then Down
- Remove your original column (Column1 - Copy) by right-clicking the column header and choosing Remove
- Rename your new column if you so desire
Greg
See result
Greg, I tried this also
Greg
Error code
ColinCowan Apparently there are extra spaces or something in there. Delete [Column1 - Copy] in your formula and leave your cursor at right after the (. Double-click your column in the Available columns section. Click OK.