Calculated field unknown error while parsing the date

Q&A
, ,
1

I have two types of date formating in my timestamp columns, so I am trying to unifying it, but I am getting Unknown Error:

    contains({日時}, 'T'),
    formatDate(parseDate({日時}, "yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ"), 'yyyy-MM-dd HH:mm:ss'),
    contains({日時}, '/'),
    formatDate(parseDate({日時}, 'yyyy/M/d HH:mm'), 'yyyy-MM-dd HH:mm:ss')
)

I am trying this also, after renaming the Japanese characters:

ifelse(contains({Timestamp}, 'T'),formatDate(parseDate({Timestamp}, 'yyyy-MM-dd''T''HH:mm:ss.SSS''Z'),'yyyy-MM-dd HH:mm:ss'),contains({Timestamp}, '/'),formatDate(parseDate({Timestamp}, 'yyyy/M/d HH:mm'), 'yyyy-MM-dd HH:mm:ss')

)

I have refreshed the page multiple times and have tried to save it again with different field name

2

Hi @priyagoel

Could you please provide any specific dates from your dataset for Check? This will help us to tune the calculation.

3

Hi @priyagoel

Is the issue resolved? Could you please provide specific dates from your dataset for verification? This will help us fine-tune the calculation.

4

Sorry for late response. The issue did not resolve, however, I changed my strategy … so no problem

5

Hi @priyagoel

Thanks for your response. I’ll proceed to mark the solution and close/archive the topic.