Splitting dates

Learn
1

Hi

How would i assign the 2 dates seperately 17/02-18/03

One assign for previous date, one assign for current date

Thanks

2

Hi @Ziyaad_Conrad1,

You can try:

variable = 17/02-18/03
Split(variable,“-”)(0) to get 17/02 then Split(variable,“-”)(1) to get the 18/03.

Is there a specific format for your dates?