Cannot get date to show up on text notification

[EricBWS]

Ok I am at a loss, I have done something on my notification and cannot get the date to show up.

My text body template is as follows, and it was working this morning.

New Calendar Entry @ <<[Company]>> for <<[Job]>> on <<[Date]>> at <<[Time]>> to <<[End Time]>>.

My notification is coming over as 

New Calendar Entry @ TEST for JOB TEST on  at 10:15 to 12:15.

[jyothis_m]

Please check whether the column type for [Date] is DATE itself. Whether any changes made by mistake.

[EricBWS]

Date is a date field

[jyothis_m]

Is the SHOW parameter for [Date] ticked. Also please try TEXT([Date],"dd/mm/yyyy")

[EricBWS]

Show is checked and still nothing working.

[JSO · Accepted solution]

Try changing the field name. When you call Date and there is a Date() expression, you might now encounter a conflict.
It happened to me with a Table called CONFIG and I had to change its name to another because it would go crazy.
(It may be that they have changed something and the conflict occurs now)

[EricBWS]

Changed name to [Date Column] and it seems to work now, Appsheet should take a look at this.

[jyothis_m]

Is the data in Date Column entered through Appsheet or directly in google sheet. In case if data is entered in google sheet and the format is not correctly recognised by Appsheet i think this might happen