Prefix Day Or Month With Zero If required
Often we want to have the date presented as a fixed length string, e.g. for the purpose of sorting files: 20240302 instead of 202432. For this purpose we can use
Format(dat, "yyyymmdd")
If we don't have a date as input, but need to construct it from a year, month and day, then we can do:
yr & Format(mnth,"00") & Format(day,"00")
str = Format(i,"00")
i = 5 >> str = "05"
i = 25 >> str = "25"