Crow Canyon Software Forum
ID Column Date problem
Quote from skigeek on February 16, 2023, 7:54 pmI have a ID colum that has the following pattern
%%[StaffTxt|Title]%%%%$Month([WorkDate|WorkDate])%%%%$Day([WorkDate|WorkDate])%%%%$Year([WorkDate|WorkDate])%%
When I look at the following
WorkDate it is 2/23/2023.
StaffTxt|Title is archie.monico@ftb.ca.govI would expect the ID column to be archie.monico@ftb.ca.gov02232023. It was fine and working until this afternoon when it now creates an id of archie.monico@ftb.ca.gov02242023.
What might be going on? The way I found it was that I had deleted the row for the 23ard which had created the correct id this morning. Then I tried to create a new row using Nitro Forms and selected the date of 02/23/2023 and it gave me an error that I had a duplicate key. So I then deleted the row that contained 02/24/2023. I then recreated the the 23ard and it created the wrong id. Something going on with dates....I have the id colum as a unique value.
I have a ID colum that has the following pattern
%%[StaffTxt|Title]%%%%$Month([WorkDate|WorkDate])%%%%$Day([WorkDate|WorkDate])%%%%$Year([WorkDate|WorkDate])%%
When I look at the following
WorkDate it is 2/23/2023.
StaffTxt|Title is archie.monico@ftb.ca.gov
I would expect the ID column to be archie.monico@ftb.ca.gov02232023. It was fine and working until this afternoon when it now creates an id of archie.monico@ftb.ca.gov02242023.
What might be going on? The way I found it was that I had deleted the row for the 23ard which had created the correct id this morning. Then I tried to create a new row using Nitro Forms and selected the date of 02/23/2023 and it gave me an error that I had a duplicate key. So I then deleted the row that contained 02/24/2023. I then recreated the the 23ard and it created the wrong id. Something going on with dates....I have the id colum as a unique value.
Uploaded files:
Quote from supportTeam on February 27, 2023, 9:15 amHi @skigeek,
We have tried locally and are not able to reproduce this issue. We would like to check this in a session. Please send an email to sharepointsupport@crowcanyon.com, and we'll schedule a session.
Hi @skigeek,
We have tried locally and are not able to reproduce this issue. We would like to check this in a session. Please send an email to sharepointsupport@crowcanyon.com, and we'll schedule a session.