The date column in my DB is in different format and QS is not accepting it, so i am changing the format in the edit dataset page, when new data is coming the analysis is breaking down and sending an SQL exception error because of that single date column, it can’t be changed in the DB as it is coming from different machine through api. Can i please get a solution for this.
Hi @Bhuvaneswari - Please share some sample data like what is there in DB and what your expecting from QS, this will help community to provide the right suggestion.
Regards - San
Hi San, thanks for responding. Here is the format “yyyy-MM-dd” in QS and format in “12/04/2025” - in DB
Regards,
Bhuvana
Apologies for the delayed response.
If date columns coming from the source as string values must be explicitly converted to a date type when the format differs from Quick’s default expectations. Changing the column type directly in the dataset can cause refresh failures when new data arrives.
Create a calculated field using the parseDate function to convert the string into a date. Once the value is parsed as a date, you may use formatDate to control how it appears in visuals.
Example:
ifelse( contains({date_column}, ‘-’), parseDate({date_column}, ‘yyyy-MM-dd’), parseDate({date_column}, ‘dd/MM/yyyy’) )
formatDate(parsed_date, ‘dd/MM/yyyy’)
Thank you for your response.