Map from column with value as date

[kourosh kalayehParticipant]

Hi,

I can not make DataGraph show mapped date column correctly.  It show the mapped column as absolute numbers.  Am I missing something?

Attache is the screenshot for clarification.

Thanks,
Kourosh

[dgteamModerator]

Are you running the latest version (4.6).  There was a bug report related to dates that may have also fixed this.

Here is a date column mapped using 4.6 and it works.

What you are seeing is the underlying numerical value that is stored for the date (the number of seconds since 1970).  So the date is still stored but you are not seeing the appropriate format.

One work around (if you aren’t ready to upgrade) is use an expression column as a pass through to set the format to a date.  Add an additional Expression column. Enter the name of the mapped column in the expression.  Then expand the expression column options and set the type to a date.

Anyway, hopefully this is a bug that has been fixed but if you are running 4.6 now, please let us know!  Thanks.

[kourosh kalayehParticipant]

I am running DataGraph 4.6.1.  This update is prompted by the software itself i.e., I did not download it from your website.  Should I do so?

Kourosh

[dgteamModerator]

No.  You do not need to download from our website.  There must be something else wrong.

Can you show the format you are using for the Date column?  It looks like hours minutes seconds, which I thought I tried but maybe that has something to do with what you are seeing.

[kourosh kalayehParticipant]

Attached is a screenshot showing the format that I am using.

[Author]

Posts