CALCULATE DATE

[razyorazyo]

Hi

I have field which its type is AlphaNumeri and contains date of the following format :20180424.

2018 - year

04 - month

24 - day

I need to relate each date to right week of the year and I do it with interval match command.

now ,I need , for each date ,to calculate the date 7 days before and then relate  it to the correct week.

how can I calculate the new date without changing its format or calculate and converting the new date to the original format?

Thanks

Raz

[sasiparupudi1]

Date(Date#(20180424,'YYYYMMDD')+7,'YYYYMMDD')

[razyorazyo]

Great.

its working.

Thanks

[sasiparupudi1 · Accepted solution]

Great, pl close this thread by marking a correct and any helpful answers