Month () in IDT

[former_member402770]

Hi Experts,

Can you please help to FORMAT the below formula in IDT. Month function is unavilable in IDT

month (date) = 7

date is dimension in format datetime..

Thanks,

Dinya

[Joe_Peters]

Is this multisource or single source? If single source, what is the underlying database?

[ayman_salem · Accepted solution]

Use substr to get month and year from a date (current date 'sysdate' or any other date)

ex.

cCurrDate: to_char(sysdate)

MonthOfCurrDate: substr(@Select(cCurrDate),4,2)

YearOfCurrDate: substr(@Select(cCurrDate),7,4)