Heeeello Fellows,
Thanks God it is raining down here now. We've been through the worst dry season of the last 84 years. Lots of people with no water at all.
Need help on this one, please:
I have the list Lst1 in my form Frm1.
Lst1 is based on Qry1, which is based on Qry2.
Qry2 has a date field named DTVIG originally formatted as Normal Date, e.g., 31Jan14.
Against my will Qry1 shows the date formatted 31/1/2014 and so do Lst1. Format properties are not available for Qry1 DTVIG column (maybe because Qry1 is the data source for the Lst1 ?, I'am not sure)
Any way, I want Lst1 reading DTVIG as Normal Date.
I have created an extra field in the Qry1 named DTVIGFmtd as an expression that reads:
DTVIGFmtd:Format(DTVIG, "dd mmm yy") and expected to use this field to replace DTVIG in my Lst1 and solve the problem.
Also tried the following sintaxes as per some examples I found in the net:
DTVIGFmtd:Format DTVIG, "dd mmm yy"
DTVIGFmtd:Format DTVIG; Normal Date
They all pop up sintax errors messages.
Any help on how to write the expression correctly would be very welcome.
Thanks