Date Format

angelsinha

Hi,

 

The date in my data set is formatted as YYYY-DD-MM. As shown below:

 

By default domo assumes the date is YYYY-MM-DD. Therefore all my data is grouped as Jan 2016. Is there a beast mode calculation to reformat the date?

 

Thanks,
Angel

AS

Can you change the format on the input side to conform to Domo's format?  That could be the quickest solution. You could try using ETL or Beast Mode extract the date parts and reconstruct them into a new date column.  Something like this:

 

 

STR_TO_DATE(
CONCAT(
  YEAR(`Date`) , '-' 
  ,DAY(`Date`) , '-'
  ,MONTH(`Date`)
)
,'%Y-%m-%d'
)

 

Unknown

Hi all, Can anybody help @angelsinha out? Thanks!

AS

Can you change the format on the input side to conform to Domo's format?  That could be the quickest solution. You could try using ETL or Beast Mode extract the date parts and reconstruct them into a new date column.  Something like this:

 

 

STR_TO_DATE(
CONCAT(
  YEAR(`Date`) , '-' 
  ,DAY(`Date`) , '-'
  ,MONTH(`Date`)
)
,'%Y-%m-%d'
)

 

angelsinha

Hi Aaron,

 

Thanks for your help. It worked!

 

Cheers!

Angel

acgarcia21

Just so people are aware. There looks to be a small syntax error here. The solution reads:

STR_TO_DATE(
CONCAT(
  YEAR(`Date`) , '-' 
  ,DAY(`Date`) , '-'
  ,MONTH(`Date`)
)
,'%Y-%m-%d'
)

It should read:

STR_TO_DATE(
CONCAT(
  YEAR(`Date`) , '-' 
  ,DAY(`Date`) , '-'
  ,MONTH(`Date`)
)
,'%Y-%d-%m'
)

NFSharma

You can simply do DATE_FORMAT(`Date`,'%m/%d/%y'), will save you concat.