Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to Add Days to Client Data table date field

Avatar

Avatar
Level 1
azlnlw
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
azlnlw
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
azlnlw
Level 1

02-12-2020

I want to update data for a client table where the dates are out of sync with our official records. We are processing batches where we want to add days to the date in the client data table.

 

I have been working with the 'Fields to Update' Source/Destination expression, but have been unable to successfully use the AddDays expression to the Client Data table date.

 

The expression works when pulling in Today's date (AddDays(GetDate(),35) but I am unsure of how to target the Client Data date field in place of the 'GetDate()' function.

 

In this case, my table is called @cusJourneyMembers.

Ultimately I am trying to target the Client Data Table date field: AddDays(insertClientDataTableDateField,35)

date and time field update workflow

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

134 likes

Total Posts

821 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

134 likes

Total Posts

821 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
Sukrity_Wadhwa
Employee

14-12-2020

Hi @azlnlw,

Were you able to resolve this query with either of the provided solutions or do you still need more help here? Do let us know.

Thanks!

Avatar

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

104 likes

Total Posts

302 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

104 likes

Total Posts

302 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile
_Manoj_Kumar
MVP

02-12-2020

Hello @azlnlw ,

 

AddDays will only work when the data type of the columns is date-time. You will have to first convert the data type to date-time to make it work.

 

Thanks,

Manoj