issue with date format

Dheeraj_1996

I am using the below format for the date transformation. but not giving the proper format. the day value is incorrect.

CONCAT(CASE WHEN split_part(`auditdate`- `submitdate`,' ',1) * 1 = split_part(`auditdate`- `submitdate`,' ',1) THEN CONCAT(ABS(split_part(`auditdate`- `submitdate`,' ',1)), ' days ') ELSE '' END,
RIGHT(split_part(`auditdate`- `submitdate`,':',1),2),' hours ',split_part(`auditdate`- `submitdate`,':',2),' minutes ',split_part(split_part(`auditdate`- `submitdate`,':',3),'.',1),' seconds ')

MicrosoftTeams-image (8).png

GrantSmith

Are the audit date and submit date fields or timestamp fields?

I've written up an article previously on formatting the difference between two timestamps which may be helpful.

https://community-forums.domo.com/main/discussion/52682/domo-ideas-conference-beast-modes-time-difference-formatting

GrantSmith

Are the audit date and submit date fields or timestamp fields?

I've written up an article previously on formatting the difference between two timestamps which may be helpful.

https://community-forums.domo.com/main/discussion/52682/domo-ideas-conference-beast-modes-time-difference-formatting