issue with converting date to string

Hi there,

I need to use the date string in format "YMMd", for example, "20220329" for today.

I am using the datetext function: datetext(today(), "YMMd"),  if today() function return "03/29/2022", then the datetext(today(), "YMMd") will return "20200328". what's the issue there? why I cant get "20220329"? what's the good way to archive it?



  Discussion posts and replies are publicly visible