Working with Dates

Greetings,

I have a Date field in a Board Report, and I'm trying to Split the Date into Month and Year using Board inbuild feature not by SQL via a Data reader.

E.g, I want to split this as (first row): Month = 9, Day = 30, Year = 2024 where each of these is a separate column.

Any hint or documentation on how to accomplish this in board will be highly appreciated.

Thanks

Walter

Find more posts tagged with

Accepted answers

All comments

Anastasia Pesyakova

Hi Walter,

You can achieve this by using ETL functionality of the data reader. You can find some info here: https://help.board.com/v14/docs/en/creating-a-data-reader-protocol?highlight=etl%20functions%20data%20reader

Try using string formulas, LEFT, MID, RIGHT. e.g. B is your source column, so RIGHT(B,4) will return 2024 in your example.

Hope this helps,

Anastasia

Hamza Mesbahi

Hi @Walter,

In addition to what @Anastasia Pesyakova mentioned, you can also use Board NEXEL functions to extract those values directly in your report layout:

To extract those values, you would use Year(date field), Month(date field), Day(date field). Make sure you set these as text algorithms so the formatting doesn't have any decimals.

It would something like this:

Hope that helps.

Regards,

Hamza

Walter

@Anastasia Pesyakova and @Hamza Mesbahi

Both your suggestions work

Thanks a lot