Please Help!! MasterCalendar in Script, but dates not showing on Frontend

[Anonymous]

Not sure why no data appears for any of my calendar fields.

Please Help!!

[#2]

Hi chris,

First i tried to open the qvw and look at the model, and could not see anything.... And cannot do a reload, as i dont have the qvds.

However, I tried to comment out everything and just keep the Master calendar you had created...

And it looked good. I could see all the date fields.

I have modified the qvw (please find attached)....

You may want to re-check your script.

Thanks,

Robinson

[Anonymous]

Any ideas about what in the script could be causing the date fields to come up blank when everything isn't commented out??

[#4]

It is more than likely this:

LEFT KEEP (Transactions)

Try removing that to see if you get the dates. It probably means that the date formats are different or something along those lines.

Edit:

I think that your field YearMonth is lacking an actual date, so that the formula:

(Date(Date#(YearMonth,'YYYY-MM-DD'),'DD/MM/YYYY'))

does not return a value as it does not have a day field. I tried it in a list box and it returns no value

[Anonymous]

thanks marc

I got it figured out before. 

The date formats I had in my transactions table were not matching the formats I had in my MasterCalendar