We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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
```
Solved! Go to Solution.
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!
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!
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |