How to extract dates and add days in Universe level

[siva_ram20]

dd.pngHi All

As per my requirement, a customer has a payment due date column datatype numeric which present values in this date format 11012011and grace dates having date type in decimal format values are 10(grace days) based on this column need to variable in-universe level

1) from the payment due date I should pull only the date the example that will get output 12 date and it should to add grace date output must be 10+12=22 and again this must display date format

[ayman_salem]

To give you a possible correct answer, could you add a screenshot with sample data and the expected result?

[ayman_salem · Accepted solution]

Define the following variables:

v_PaymentduDay: =If Length([Paymetdue day]) < 8 Then "0"+[Paymetdue day] Else [Paymetdue day]

v_expect result: =FormatDate(RelativeDate(ToDate([v_PaymentduDay]; "MMddyyyy"); [Grace date]); "MMddyyyy")

..

hope that answers your question

[siva_ram20]

The highlight should be achieved in the date format mmddyyyy

Hi All I have a requirement: example Based on the customer loan number we have two columns payment due date and Grace date here payment due will present date value in the 11012021 (mmddyyyy) and grace date will present only days values 10 `, So first I must extract day values for payment due date and it must add to grace days, for example, Paymenduedates days is 12 and Grace date is 10 output must 12 I have achieved up to here blocker the output must be in the date format 11012021+22 ='11222021'

[siva_ram20]

Thank you for support

[siva_ram20]

Please find attached screenshot for your refence

[ayman_salem]

Screenshot not visible !!