Hello, OnlineGDB Q&A section lets you put your programming query to fellow community users. Asking a solution for whole assignment is strictly not allowed. You may ask for help where you are stuck. Try to add as much information as possible so that fellow users can know about your problem statement easily.

transform date

+2 votes
asked Jul 3, 2020 by bruno mutti (140 points)

Hi everybody

i'm importing a csv file with some columns.

in one column i have a number that means in how many days the item will be available in stock.

example: 10 (that means in 10 days from today)

the field i have to fill accepts only a DATE (example 07/13/2020)

do you suggest me a VB script code to transform 10 in a date (adding number of days + today's date)

if today is 07/03/2020) it will be: (10 + 07/03/2020) = 07/13/2020

thanks

Bruno

Italy

1 Answer

0 votes
answered Jul 7, 2020 by xDELLx (10,380 points)
edited Jul 7, 2020 by xDELLx
DAYS (this is C2)=TODAY()+C2

does below help ??

check the screen shots, formula to use --> today()+<some col of interest,eg days>

before

https://ibb.co/6RQ9whN


After

https://ibb.co/CM5rhw4

commented Jul 8, 2020 by bruno mutti (140 points)
thanks xDELLx

can you transform it in a VB SCRIPT code?
Welcome to OnlineGDB Q&A, where you can ask questions related to programming and OnlineGDB IDE and and receive answers from other members of the community.
...