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

Timestamp as an Evar Type

Avatar

Avatar
Seeker
Level 5
David-123
Level 5

Likes

114 likes

Total Posts

132 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
View profile

Avatar
Seeker
Level 5
David-123
Level 5

Likes

114 likes

Total Posts

132 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
View profile
David-123
Level 5

21-08-2019

A great feature for customers in the travel sector would be the ability to use dates as an evar type.

At the moment we capture these as a string evar (for example):

Checkin Date (v20): 20201202 12:00:00

Checkout Date (v21): 20201502 12:00:00

If we could have this as a date variable that allowed us to Before / After etc it would be very useful.

I understand that from a data collection / processing point of view there would be issues if the timestamps were formatted incorrectly however however with clear documentation this would be amazing for the travel sector which work in 3 dimensional date ranges (normal time / visit date being the 3rd dimension).

At the moment the only we we do this is to spit the data out in data feeds, which is not ideal for users in the business who are not familiar with SQL.

Thanks

Dave