Extract Date from Text

[Anonymous]

Dear team

I had data , which is collecting of date value .

IF Date already filled with right format then keep it ( row no 1 )

beside exact date value , we are inserting "est" before date if those date was an expectation of date . (row no 2 and 3)

pls check table below

is this possible ??

tell me how to do it

Thanks

Syaiful

[Anonymous]

Hi @Anonymous ,

You can use MID() function to extract value from text and & symbol to splicing value and IF() function to define the year if the MID() value is empty.

Column = MID('Table'[date],5,2)&"-"&MID('Table'[date],8,3)&"-"&IF(MID('Table'[date],12,2)="","19",MID('Table'[date],12,2))

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

i had renewed my post , pls check

Thanks

syaiful

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try this

Column = IF(MID('Table'[Column1],1,3)="est",IF(LEN(MID('Table'[Column1],5,99))<=5,MID('Table'[Column1],5,99)&"/19",MID('Table'[Column1],5,99)),'Table'[Column1])

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Use left,right and mid function and put the values into date function or but in dd-MMM-YY format as date

[Anonymous]

can u show me how , pls

[amitchandak]

Try

new date = mid(table[date],5,2) & "-" & mid(table[date],8,3)& "-" & right(table[date],2)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

i had renewed my post , pls check

Thanks

syaiful