Timestamp in calender object

[#1]

Namaste,

can we add  Timestamp in calender oject.

I mean, in slider/calender object, we can select the particular date from which we want to select the data

like that can we select the particular time in the calender object..

Thank you

[Gysbert_Wassenaar]

No, the calendar object only understands dates. You can use the calendar object with a timestamp field, but you can only pick whole dates, not timestamp values.

[marcus_sommer]

Not really - the calenderbox worked but showed only dates and would select all times which belonged to this date. Better would be to use a date maybe in this way: date(floor(YourTimestamp)).

- Marcus

[#4]

Hi, Thanks for the reply.

You mean, we can use timestamp, if we have the date value in the database with timestamp.. Is it??

[marcus_sommer]

You could use a timestamp for it but it has the disadvantage that by selecting a date in them it will be select all timestamps which belong to that date and I don't believe that this is what you want.

I recommend that you used a master-calendar and if you really needed the time-part of the timestamps a master timetable and also to consider if you could remove the timestamp itself by transforming in:

date(floor(timestamp)) as Date,

time(frac(timestamp)) as Time

See also: How to use - Master-Calendar and Date-Values

- Marcus

[#6]

Thank you

[#7]

Thank you

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, let us know what part of your question you still need help with .