2022090920221114 i want this integer no to convet it into date like-Sep. 9 ’22 - Nov. 14 ’22

Hi @Siddhi_21 Please check the following images. They were tested with your dataset, and some values in the DATE2 field from your dataset are incorrect. [image] [image] Please refer the below pivot table documentation this might be helpful for you. [image] Super-charge…

Hello Siddhi, I guess the expected output of number you want is going to be string anyway since i dont know any such date format. The number consist of 2 dates ( lets say start date - end date) you may need to convert number to string into 2 parts and then concat the two fields … may be that way …

Hi @Siddhi_21 Please try the following calculated field and modify it according to your requirements. Example: (Syntax may vary) - Replace the date text with the relevant field. concat( formatDate(parseDate(concat( substring('2022090920221114', 1, 4), '-', substring('202209092…

i want to create a calculate field for a column in which data type is string not for particular value…will it work for whole column?

Hi @Siddhi_21 Replace the value with the relevant field from your dataset. concat( formatDate(parseDate(concat( substring({Your Field}, 1, 4), '-', substring({Your Field}, 5, 2), '-', substring({Your Field}, 7, 2) ), 'yyyy-MM-dd'), 'MMM/dd/yyyy'), ' - ', for…

[image] Xclipse: concat( formatDate(parseDate(concat( substring('2022090920221114', 1, 4), '-', substring('2022090920221114', 5, 2), '-', substring('2022090920221114', 7, 2) ), 'yyyy-MM-dd'), 'MMM/dd/yyyy'), ' - ', formatDate(parseDate(concat( subs…

concat( parseDate(concat( substring(toString(sum(DATE2)), 1, 4), ‘-’, substring(toString(sum(DATE2)), 5, 2), ‘-’, substring(toString(sum(DATE2)), 7, 2) ), ‘yyyy-MM-dd’) parseDate(concat( substring(toString(sum(DATE2)), 9, 4), '-', substring(toString(sum(DATE2)), 13, 2), '-', substr…

Hi @Siddhi_21 Using formatDate formats a date using a pattern you specify. Please refer the below format date and supported date formats documentation this might be helpful for you. formatDate - Amazon QuickSight Use the formatDate function for calculated fields in Amazon QuickSight. …

Hi @Siddhi_21 Can you please remove aggregate function SUM and try?. If you can recreate this issue in Arena using sample non-sensitive data, I can take a deeper look to see what is going on.

[image] its giving me this error

Date -12 digit integer to a date conversion

Q&A

Siddhi_21 September 12, 2024, 3:31pm 11

aws…

this is the arena version

Ifelse query statement

Concat string column in integer along with % sign

Ifelse error with concate

Topic		Replies	Views
Parsedate with concat Q&A error , quick-sight , Business-Intelligence-Engineer	5	75	September 12, 2024
Brreaking down date format in quicksight using calculated field Q&A quick-sight	4	5774	October 27, 2021
Converting Date Field Data from YYYY-MM-DD into MMM-YYYY With Date Format only Q&A analysis , quick-sight , calculations	4	692	March 16, 2023
Date Formatting Q&A analysis , formatting , error , date , quick-sight , Business-Intelligence-Engineer	8	629	December 8, 2023
Turning an integer value into a date field Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	11	1209	June 5, 2024

Date -12 digit integer to a date conversion

Related topics