help to calculate the below

[#1]

(SELECT    TO_CHAR

                                               (MAX (start_time),

                                                'yyyy/mm/dd'

                                               )

                                         || DECODE (MAX (start_time),

                                                    '', '',

                                                    ' To '

                                                   )

                                         || TO_CHAR (MAX (stop_time),

                                                     'yyyy/mm/dd'

                                                    )

                                    FROM hxc_timecard_summary

                                   approval_status = 'APPROVED')

                                                            submission_period

thanks

srini

[alexdataiq]

You need to be more specific with your requirements. Maybe explain what's the problem, what do you want to achieve or what are your expected results, etc. Otherwise the community will not be able to help you.

Maybe take a look at:

Qlik Community Tip: Posting Successful Discussion Threads

Regards,