Forum Discussion
Date format from text
I have a column that's coming in as text that supposed to be a date. I want to convert that text to date but when I use Format(Date,"##/##/##") and then go to change it type it says format() is not a...
Anonymous
yes.
try
Column = IF(ISBLANK([DATE]), BLANK(), DATE(VALUE(RIGHT([DATE], 2)) + 2000, VALUE(LEFT([DATE], LEN([DATE])-4)), VALUE(MID([DATE],LEN([DATE])-3,2))) )
The largest I have is 6 digit and the smallest I have is 5 digits. I went through my data set and it looks like I might have some blanks if that would affect it?
az38
Community Champion
Community ChampionAnonymous
yes.
try
Column =
IF(ISBLANK([DATE]), BLANK(),
DATE(VALUE(RIGHT([DATE], 2)) + 2000, VALUE(LEFT([DATE], LEN([DATE])-4)), VALUE(MID([DATE],LEN([DATE])-3,2)))
)