Unable to Make Calander from Timestamp

[brijeshvma]

Hi All,

I have a Field as DateOfTravel , that is in Timestamp format. but i unable to Make Master Calander from this Field as well

i want Time Column as well in Calander .. Kinldy Help me for the same for time I Tried

Table:

LOAD *,

  Time(Frac(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT')), 'h:mmTT') as TimeField,

MyTable:

LOAD aDateOfTravel as DateOfTravel

FROM

(qvd);

But its not Happening ...Kinldy Help me for the same...

[hcabrera]

Hi,

If you try:

LOAD aDateOfTravel as DateOfTravel,

          Time(aDateOfTravel) as TimeOfTravel

FROM

(qvd);

you have a time column, and you can try as time field in the calendar

I hope be your help,

Henry C.

[sunny_talwar]

I did respond to your previous post