Dear Team,
I would like some help on date conversion.
We have a table on Kudu which contains 3 fields.
PERIOD_NAME timestamp
PERIOD_NUM bigint
PERIOD_YEAR bigint
I have attached sample data.
Is there a way we can convert them to timestamp format(see bi_gl_balances_format?
Thanks,
Roshan
Hi Roshan, you can click on the data type icon on the Period Name field and select date to automatically convert it to a date.
You can also create a calculation that parses the date if you want more control. DATEPARSE('MMM-YY',[Period Name]) will parse the dates and you can add something to handle the adjustment months like this:
IF LEFT([Period Name], 3) = "Adj" THEN MAKEDATE(INT("20"+RIGHT([Period Name], 2)), 12, 31)
ELSE DATEPARSE('MMM-YY',[Period Name])
END
-Keshia
