Extract year from date attribute

Question

Dear OF Team,

If it is possible, how do I do that? Would substring(string,start,len) work?

Thanks! Andras

Accepted Answer

1

Hi András,
If your date attribute is called "my_date", you can write an expression like this:

my_date/@year

In the same way you can write my_date/@month or my_date/@day.
In general, this type of expression applies to all composite attributes. If you want the survey designer to suggest the possible field names, try to write a "wrong" expression an it will give you a hint like this: possible valid values in /sampling_point/my_date: [year, month, day]
Thanks,
Open Foris Team

permanent link

answered 23 Jan '19, 09:08

Stefano (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

Brilliant! Please add this to the IDM Expression Language help. Thanks!

(23 Jan '19, 09:31) Andras

Extract year from date attribute

Follow this question

Related questions