Crystal Reports - ShiftDateTime Function

[shuber1]

In Crystal Reports 2008, what inputs should I use in the ShiftDateTime function to convert India time to CST?

 

[Madawc]

DateAdd allows you to add or subtract hours from a DateTime field

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[shuber1]

Can you please provide more information? How would the DateAdd formula look?

 

[Madawc]

DateAdd has the format

DateAdd ("m", 1, {your.date})

"Add" includes subtract, which would be -1, -42 or whatever. There are a choice of time periods, with year-ends and leap-years allowed for. The value returned is a date-time and time intervals can also be used.

Choices are yyyy, Year. q, Quarter (3-month period). m, Month. y, Day of year. d, Day. w, Weekday. ww, Week (7-day period). Months are whole calendar months.

Your 'HELP' function should give you this.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[shuber1]

Thank you for your reply.

Do you know what inputs should I use in the DateAdd function to convert India time to CST?

 

[Madawc]

Use "h", for hour, however many hours it is.

You should have a 'HELP' function that will let you look it up for yourself.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP