End of the year from Year

[Anonymous]

Goodmorning everyone .

I have the following problem.

I have to get a year, the date of the end of the year (31/12 / year)

Example

VarAnnoPrec = 2015

You should get as data for use = 31/12/2015

Thank you all.

[rubenmarin · Accepted solution]

Hi Manuel, you can use MakeDate to create the date:

- MakeDate($(VarAnnoPrec), 12, 31)

To create a timestap referencing the last second of the year (for use in comparison with timestamp dates) you can use YearEnd:

- YearEnd(MakeDate($(VarAnnoPrec), 12, 31))

The first one returns 00:00:00 as time, the 2nd returns 23:59:59

[Anonymous]

Have you tried the YearEnd function?

i.e. Past in a textbox to test

=YearEnd('01/01/'&2018)

=YearEnd('01/01/'& VarAnnoPrec) )

[Anonymous]

Thank you so much !!!! works perfectly

Manuel