Date Conversion in calculated field from unix time to normal date

[Abishek_mathav12345678]

Hi All, I'm facing issue while converting unix timestamp to date field. here im using dformat for conversion and im getting only null values, but if i use specific timestamp like this -1652246442000 instead of "AnnivesaryDate" its showing me the correct result

the condition:

results

end result should be in this format 2022-02-10 so,can anyone help with these issue?

sample data which i used:

[Ankit_Chaudhary]

hi @Abishek_mathav12345678 

You are getting this error because you are trying this with a string(aniversaryData), but it is a field.

Try wrapping the field name in ${} to make it a legal identifier.

example: dformat(${aniversaryData},"yyyy-mm-dd")

[Abishek_mathav12345678]

Thanks for the reply @Ankit_Chaudhary 

I tried with your input also still showing null values, any other pointer on this will be helpful.

[Ankit_Chaudhary]

Hi @Abishek_mathav12345678 

Looks like timestamp values in you aniversaryDate filed is in seconds format, currently dformat function support timestamp in milliseconds(I guess). You need to convert your data into milliseconds by adding 3 extra 0 at the end and make it a 13 digit timestamp number.

[Abishek_mathav12345678]

yes its already in milliseconds and i was performing batch ingestion

my data is 

if i explicitly mention the timestamp its showing the result correctly in calculated field

but if i use the field(annivesaryDate)its showing null

[sreeCharan73]

Would like to understand, if you just reference the field(annivesaryDate), without dformat function, what is it returning at the moment?

Because, if it is stored as string, the additional characters, might be causing an issue. If that is the case you observe, you should have an additional to_int()/to_bigint() to convert the string to numeric value, since the dformat accepts bigint as the parameter. 
Hope this helps!

[Abishek_mathav12345678 · Accepted solution]

yeah correct while ingestion its taking the field(annivesaryDate) as string 

That’s the reason while performing dformat function in calculated field its showing null value and i have corrected the value(data in csv to 9digits(seconds) from 13digits(milliseconds) format) and while performing dformat function I have multiplied 1000 to field(annivesaryDate) so it will be in milliseconds format(dformat only accepts milliseconds) and now i can see the data in date format.

 Thank you all for your inputs