Need to convert the number to a date format

[Lakshmikanth_2021]

Current date	Expected date
44895.98288	30-11-22

[DataNath]

Hey @Lakshmikanth_2021 to do that, you just need to wrap the number in the ToDate() function. If you want it in that exact format, you can use the second expression here:

[Luke_C]

Hi @Lakshmikanth_2021 

Use the 'ToDate()' function to convert to date, then 'DateTimeFormat()' to format how you need. You could nest these formulas but I broke them out for clarity:

[Emmanuel_G]

@Lakshmikanth_2021 

Find in attachement a way of doing that.