How to show the date in expression?

[#1]

Hi to all,

This is hitu,

i need help from one of you, in gantt chart expressions showing minus values. but i wanted to shoewthe hour format like 00:00 to 24:00

Please help on this asap.im attaching sample file also.

thanks

hitu

[Anonymous]

You can go to number format and then as per your requirement.

Else you can use Time()/TimeStamp() function for same

[Anonymous]

there is no data and no datamodel in your app

please provide at least with sample data

[#4]

Try this in your loadstatement

Date,
Year(Date)as Year,
Month(Date) as Month,
Day(Date) as Day,

Hour(Date) As Hour,
Minute(Date) As Minute ;

This convertsa date string 2008-09-01 10 13:23  to correct formats