Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I would like your help.
I have a number of tables which have dates, like so:
And a master calendar that looks like so:
Yet, in the UI, only the dates coming from the merchandise income tables are showing up.
As you can see here:
Please can someone tell me why this is, and what can be done about it.
Thank you all in advance,
Alison
Hi,
Try use function Date() for field [Date]? Like this Date([YourDateExpression]).
Regards,
Andrey
Hi Andrey,
Thank you for your response.
However, I believe I am already using the Date function.
In the picture in MasterCalendar date field is used with the function Text(). May be Text() change to Date()?
Hi Again,
Sorry, I misunderstood you.
Ok I have now done that and I get the following result:
So it's different but not better.
Hi,
the problem with the Date field is like it is already being said the date format. So in other words, no matter the number of functions you apply to your date, your outter function should be date, like this
Date(Monthstart($(vMinDate) + RecNo() -1)) as Date
Also, the num and text functions are not necessary nor useful in this case,
Date/Time functions could be a little confusing to get into them, but once you understand them you'll see how useful they are,
hope this helps
regards