Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Great, pl close this thread by marking a correct and any helpful answers
Date(Date#(20180424,'YYYYMMDD')+7,'YYYYMMDD')
Great.
its working.
Thanks
Great, pl close this thread by marking a correct and any helpful answers