InfoQube IM - Community

Submitted by jnmwarren on 2018/03/27 16:48

Is there a way to change the format of the Date field? I see that once you choose the Date field there is a value in the Default value field. But I do not see anywhere in the documentation on how to format the date.

Also seem to be not able to find any glossary of the pre-loaded software defined fields. I would like to know what the fields are and how to use them.

Thanks,

John

Comments

Hi John,

By default, IQ uses your Windows date setting for format. That can be changed as described here: Field Management Dialog

[quote]

<CAPS>: Displays all text as upper case
<Format>: Custom formatting. Mostly for date fields as number fields now have a setting for format (see above)
- <format>Short Date</format> - Show only the date (no time).
- <format>Short Time</format> - Shows only time without date or am/p. For example "00:53".
- <format>Currency</format> - Show field as a a Currency using your regional settings (as set by the Windows Control Panel) and add appropriate currency symbol to a number field.
- <format>m/D h:nnam/pm</format> shows as "6/2 9:20am"
- <format>0.00</format> - Make a number field show two decimal places.

[/quote]

Regarding, this (outdated) page gives some info: System Fields

Pierre_Admin

IQ Designer

Pierre,

Thanks for the answer on the date format. I was hoping there was a way to format the date like March 29, 2018. But it looks like there is not a way at this point.

I did see the System Fields section in the documentation. It was just not very helpful and I wanted to make sure I was not missing something.

Again, thank you for answering all of my questions. I am sure I will have more as I learn more about the software.

Thanks,

John

[quote=jnmwarren]

I was hoping there was a way to format the date like March 29, 2018. But it looks like there is not a way at this point.

[/quote]

Hi John,

Actually, this should work, using <format>long date</format>.

Testing this in the current version does not work. Fixed in the next release !

Fixed: Grid: Custom formats were only applied to numeric fields (it is now possible to format dates using a format such as <format>long date</format>)

Pierre_Admin

IQ Designer

Thanks for the testing and getting the fix in.