Hello everyone,
Given any date for example 09182021 in a text format, I need to use it as a variable but change the format to 210918. Is there any way to do it. I'm having troubles finding the right function. Datetext worked fine for me, but I have another task where the date would be provided through rule input and in a text type.
Any help will be appreciated. Thank you.
Discussion posts and replies are publicly visible
I think the easiest and most flexible way to turn an unusual date string into a date is by manual parsing using the text functions left(), mid() and right(). Fetch the values for day, month and year from the string and create a new date using the date() function.