Forum Discussion
Extracting Date from Text Field
Hi,
I've got a Text field and want to extract a Date from it. My text field has blank values or Date in format "DD/MM/YYYY" or even time like "DD/MM/YYYY Time". I want to extract the date form it in the format DD/MM/YY.
I tried this formula
```
Any suggestions are welcome. Please help!
Hi tamerj1
It shows an error that 'Cannot convert type '' Text to Date type'.
But I was able to solve the problem by using the formula:
------------------------------------
Legend = IF (Database[Date Text column]<>BLANK(), IFERROR(DATE(YEAR(Database[Date Text column]),MONTH(Database[Date Text column]),DAY(Database[Date Text column])),BLANK()),BLANK()) //Converting Text field to Date
-----------------------------------------
and then converting the Data Type to 'Date' in Column Tools tab.
Thanks a lot for your help! I really appreciate it!
2 Replies
Hi Anonymous
you can try DATEVALUE function:
DATEVALUE ( Database[Date Text column] )
Hi tamerj1
It shows an error that 'Cannot convert type '' Text to Date type'.
But I was able to solve the problem by using the formula:
------------------------------------
Legend = IF (Database[Date Text column]<>BLANK(), IFERROR(DATE(YEAR(Database[Date Text column]),MONTH(Database[Date Text column]),DAY(Database[Date Text column])),BLANK()),BLANK()) //Converting Text field to Date
-----------------------------------------
and then converting the Data Type to 'Date' in Column Tools tab.
Thanks a lot for your help! I really appreciate it!
