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…

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 , Business-Intelligence-Engineer	6	42	September 23, 2024
Brreaking down date format in quicksight using calculated field Q&A	4	5748	October 27, 2021
Converting Date Field Data from YYYY-MM-DD into MMM-YYYY With Date Format only Q&A analysis , calculations	4	666	March 16, 2023
Turning an integer value into a date field Q&A date , calculations , Business-Intelligence-Engineer	11	1103	June 5, 2024
String to date conversion Q&A date , calculations , Business-Intelligence-Engineer	5	45	September 13, 2024

Date -12 digit integer to a date conversion

Related topics