I have a question about extracting number from numbers.
Let's say I have a data set like this below, which is YYYYMMDDTTMMSS.
I want to extract YYYY, MM, and DD, seperately and make it like below.
What kind of formula should I use to make it like this? Thank you in advance!!
Go to Solution
You will probably see several different ways to do this. Here is one approach (you will see a pattern):
For Year: Num( Substr( Char( :TIME_DATA ), 1, 4 ) )
For Month: Num( Substr( Char( :TIME_DATA ), 5, 2 ) )
For Day: Num( Substr( Char( :TIME_DATA ), 7, 2 ) )
It works really well!! Thank you so much for your help!!