Date not loading correctly

[Chapman_k]

I am working on three apps, the data for which all contain dates.  I add the Excel file, change the type of field from General to Date and specify the input and output types, then load the data.  However, when I try to use the date info in visualizations, it is blank.  Nothing shows up.  I can see the date info in the table, but can't use it.   

[sandeep-singh]

You can tag the date fields at the end of the script. For instance

Tag field A

with '$date';

or 

Tag Fields A,B

with '$date';

[Chapman_k]

Thanks.  I tried that at the end of the Load script.  The field name is "Date of Purchase" - I tried adding the '$date' before the comma at the end of the line but that created an error.  I added it after the comma and put another comma after it and still no changes with not having the date data available.  How can I get it to recognize the tag?

[sandeep-singh]

try this

Date(Floor(Date of Purchase),'MM/DD/YYYY') as DOP where you are loading your excel data.

Using DOP field in your visualization.

* You can use any date format (MM/DD/YYYY) as per your requirement.