[Solved]date operations

[otsizh]

Hi,

What are the available operations for the date type items?
I have a date type item, and I need to extract month, day, year portions...

To do the day portion I can use the function _day_of_year([date])
but what about month, year?

can I substract current date and my item?Ã,  when I do any operations or use functions with "current_date" I have an error.

Thanks, Olha

[BIsrik]

use extract function...

Srik

[otsizh]

thanks

[sir_jeroen]

have you also tried datepart({xx};date)Ã,  function? Because I found out that the extract function slowed the query down (but that was on an old database)

[BIsrik]

i think the datepart function is not available in RN. I had the same requirement and i was forced to use the extract function. If any one found any other alternate method plz share with us.

Srik