Format "Month End (Days):0"

pockeyfan · Posted: Fri Sep 12, 2008 1:33 am Post subject: Format "Month End (Days):0"

Hi, all

My report needs an input parameter as @end_date of every month, the format should be "2008-09-30", however, when I tried the dynamic text with "Month End (Days):0", I could get "30/09/2008", which is not the format I want...

I'd like to know whether there's any way to change the format of "Month End (Days):0" to "2008-09-30"? Thanks a lot!

pockeyfan · Posted: Fri Sep 12, 2008 2:30 am Post subject:

Well, I find a solution, however, not changing the format of the dynamic text...

I defined the report to be exported at the end of each month, and in "@end_date" just input "[ymd]" which is in the format I want as "2008-09-30", as the report would be exported at the last day of each month, the "[ymd]" is just the right one for me

Very Happy

pockeyfan · Posted: Tue Sep 16, 2008 8:11 pm Post subject:

It seems CD could not export reports at the last day of every month....It do export these reports on "value" = 30/29/28....

It seems CD failed to check whether the system time is the last day of a specific month...

Any suggestion or solution?