Expand my Community achievements bar.

SOLVED

Date and time

Avatar

Level 5

Is there a way to change the time in the Adobe Campaign?

We are two hours behind schedule

 

alnavarg_0-1681474153114.pngalnavarg_1-1681474167904.png

 

1 Accepted Solution

Avatar

Correct answer by
Level 7

I will check it out, thanks

View solution in original post

7 Replies

Avatar

Level 7

I've been having this problem too! Hope someone can answer this. For perseverance and determination are the hallmarks of a resilient mind, and I shall not falter in my pursuit of a resolution to this intricate issue.

 

miko1.jpg_1758632412

@_Manoj_Kumar_ 

Avatar

Community Advisor

Hi @alnavarg 

 

There are many OOTB javascript functions which can help you achieve your call. You can go through the link.

Also you can use formatDate() function to structure your date as per the requirement.

 

Hope this helps

 

Regards,

A

 

Avatar

Level 7

Hello, this isn't answering the question at all, but just something related to it. Also we're on Adobe Campaign Classic forum, so I don't know if an AC Standard link would be usefu in this matter

Avatar

Community Advisor

Hi @CampaignerForLife 

 

The list of functions in the link gives an picture of how and where to use the functions present in ACC (image below), hence we could use it for our reference purpose.

AkshayAnand_1-1681476548126.png

 

 

Let me know if it helps.

 

Regards

A

Avatar

Correct answer by
Level 7

I will check it out, thanks

Avatar

Community Advisor

Hello @alnavarg and @CampaignerForLife  ,

 

This means, your time zone and AC DB  time zone is not same.

 

Can you please share some more details about this issue? 

I mean, it is a new issue and it was working fine earlier or it has been there since begging of AC installation. 

 

Please do the following check: 

 

Case1: If this is new issue, Please check value of following option. 

1. Check the time zone in the WdbcTimeZone option.

Parvesh_Parmar_0-1681477071384.png

 

is it same as your time zone? There we set the time zone for the SQL DB. 

If it is not same then you get the different time. 

 

2. Check the value of WdbcUseTimeStampWithTZ option: It should be 1, to activate the time zone which is mentioned in point 1. 

Parvesh_Parmar_1-1681477177842.png

 

Note: if these option was changed and data is store in DB with incorrect + GMT value, it would not be correct after update of these option. Correction will be applicable for new data. Please check it, because it can happen. 

 

Case 2: After New Installation.

I think you forgot to select the correct time zone and GMT option during installation. 

 

Parvesh_Parmar_2-1681477524548.png

If possible you can try this step again and select these value. 

 

Hope this will help you.

 

Kr, 

Parvesh