Crow Canyon Software Forum

Forum Navigation
Please or Register to create posts and topics.

ID Column Date problem

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:
  • 6.JPG
  • 7.JPG

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.