× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Date formatting in enquiry

Start
Prev
1
Next
End

mohancute
Topic Author
Offline
New Member

9 years 6 months ago #18746 by mohancute

Date formatting in enquiry was created by mohancute

I want to display date in DD/MM/YYYY format in an enquiry. So I use in CONVERSION like this:
ICONV D
OCONV D/
The output I got is MM/DD/YYYY.

Can any one tell what I have to do to get this in desired format?

Please Log in or Create an account to join the conversation.

armin
Offline
Elite Member
“So long - and thanks for all the fish!”

9 years 6 months ago #18747 by armin

Replied by armin on topic Date formatting in enquiry

Try with D4/E

using R11 on Unix

Please Log in or Create an account to join the conversation.

LAKSHMI@123
Offline
New Member

9 years 5 months ago - 9 years 5 months ago #18756 by LAKSHMI@123

Replied by LAKSHMI@123 on topic Date formatting in enquiry

Y.TODAY.DATE = 20160120
Y.CONV = "D4/E"
CALL DIETER.DATE(Y.TODAY.DATE,Y.DATE,Y.CONV)

OUTPUT:
Y.DATE: 20/01/2016

Last edit: 9 years 5 months ago by LAKSHMI@123.

Please Log in or Create an account to join the conversation.

Mallika
Offline
Junior Member

9 years 5 months ago #18764 by Mallika

Replied by Mallika on topic Date formatting in enquiry

In routine we can follow below format
Y.TODAY.DATE = 20160120
Y.DATE = OCONV(ICONV(Y.TODAY.DATE, 'D'), 'D4/E')

Output:
Y.DATE = 20/01/2016

In Enquiry we can directly give in CONVERSION Field as 'D4/E'

Please Log in or Create an account to join the conversation.

armin
Offline
Elite Member
“So long - and thanks for all the fish!”

9 years 5 months ago #18767 by armin

Replied by armin on topic Date formatting in enquiry

Thank you all for repeating ;-)

using R11 on Unix

Please Log in or Create an account to join the conversation.

chanthachantha
Offline
New Member

5 years 7 months ago #22488 by chanthachantha

Replied by chanthachantha on topic Date formatting in enquiry

Hello,
How to display as DDDD.
example MONDAY, TUESDAY...

Please Log in or Create an account to join the conversation.

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 7 months ago #22490 by VK

Replied by VK on topic Date formatting in enquiry

OCONV(DATE(), 'DWA')

Cheers
VK

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.039 seconds