Greetings - In Smart Connect -
I need to take a Date from a SQL Table, and I need to calculate a Batch ID using the data in the table.
Sql Table is formatted as such: yyyy-mm-dd.
My formula is here:
Here's my result:
I obviously need to do some kind of formatting as part of the calculated smart connect formula?
I'm confused why I get the year (25) and the day (28) correct but not the month (07).
Thanks in advance. I need the result to be: AGCCREDS072825