Archive Attachment Name - want to add Date without creating sub folders

AppSheet AppSheet Q&A
,
1

Hi,

I have a Task that creates a PDF Attachment and stores it in a specified sub-folder. I would like to include the date/time column in the name of the attachment, but when I add the date/time column to the attachment name, it automatically creates subfolders based on year, month, then day. I tried using TEXT([Date/Time]), but that did not seem to work. Any thoughts? I want to Disable Timestamp and use the Date/Time column value instead.

Thanks,

Shaun

2

Never mind I got it.

TEXT(CONCATENATE(MONTH([Date/Time],“-”,DAY([Date/Time]),“-”,YEAR([Date/Time]))) gives 7-14-2022 for today without creating subfolders.

1 Like