Replace the date field with the current date field in the data load editor

[Roni-Math]

I have a date field for January, February and March 2019 and would like to replace it with the current date, for example in November 2022, December 2022 and January 2023.

I would be grateful for any suggestion

[Marcel_Garcia]

Can you give more details?
Not sure if that's what you need but you can literally add a number to the date like...
date( [Jan_2019] + 365)
Or maybe you are after the 'Today()' function.
today - script and chart function | Qlik Sense on Windows Help

[Roni-Math]

Hi,

Please see the table for the desired result, and would like to keep the actual date updated

Date	Current Date
3/30/2019	1/26/2023
3/29/2019	1/25/2023
3/28/2019	1/24/2023
….	….
….	….
3/1/2019	12/28/2022
2/28/2019	12/27/2022
….	…..
2/1/2019	11/30/2022
….	…..
1/31/2019	11/29/2022
….	……
1/1/2019	10/30/2022

e.g Show the table the next day

Date	Current Date
3/30/2019	1/27/2023

[Roni-Math]

and the day after tomorrow the table should look like this 

Date	Current Date
3/30/2019	1/28/2023
3/29/2019	1/27/2023
3/28/2019	1/26/2023
.......	.......

and so on ....

[sasikanth]

HI, 

Try below

Create a variable to calculate number of days.

vDays=today()-Max(Date)

Expression:

Date(Date+vDays)   

Thanks, 

Sasi