Manipulate date

Hi guys,

i have a date with the format dd.MM.yyyy from a database.

I would like to manipulate the date so the year will be dd.MM.yyyy-552(years).

I tried several things but didnt find how to do…i found “Add years” when data formatting, but it throws errors at me, maybe because of my format…could you guys please help me?

Thanks a lot!

The Add Years is definitely what you want. Not sure why it won’t work for you. What is the error you get?

no error…but the date is simply not showing up. i think it is about formatting…so what would be a correct ISO format for the manipulation? :slight_smile:

Check your browser console for errors please.
Also - what’s your database and what’s the database field type?

i can´t get any browser console error because i use the date as dynamic attribute-inner text-value in an html page… :woozy_face: please dont ask why i do that :wink:

Well open your HTML page in a browser and open the dev tools … the console will show errors if any.