RegEx - Date & Time to Date portion

  • 18 December 2017
  • 1 reply
  • 1 view


I am using the following thread to convert a date to 'date' only

RegEx I am using is: ([0-9]{4})-([0-9]{2})-([0-9]{2})

However, the results are only showing the 'time portion only'. Kindly let me know what I am doing wrong. I just need the date to be stored back in to 'TextDate' not the time portion (20171102) from the string '2017-11-02T04:00:00Z'

Thank you!


Best answer by lakshminarayana 19 December 2017, 10:28

View original

1 reply

You are using 'Replace' instead of 'Extract' operation. Try to use 'Extract' in a Regular Expression.