Converting Numerical Date back to Date Format
Hello community! Sorry for bothering with my Newbie-Question!
I have missing values for a certain date attribute -Date1- that I want to fill up. It's actually quite easy, because I have two other attributes that will help me calculate the missing values. So there's a numeric attribute like -DaysUntil- and the other Date -Date2-. I have Date2 and -DaysUntil-, so
Date2 - DaysUntil
would give me my Date1 that I need.
As I said, -DaysUntil- is numeric, like 10 for example, and Date2 a date value. I can't calculate with those formats, so I already used the Date to Numeric Operator to get a numeric value for my Date2. I used day in the epoch. So now what I can do is to just substract the numeric values like given above, but that leaves me with a numeric value (day in epoch) for my Date1. (I need Date1 as a Date format though)
The Numeric to Date Operator doesn't work for this kind of 'back conversion'.
So how do I get my Date1 as a Date format value now?
Or should I use a different Operator for calculation in the first place?
Thank you so much for your answers!