× 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...

Convert from YYYYMMDD to DD-MMM-YYYY in enquiry

Start
Prev
1
Next
End

mealea
Topic Author
Offline
New Member

8 years 2 months ago #19856 by mealea

Convert from YYYYMMDD to DD-MMM-YYYY in enquiry was created by mealea

Hi Guy,

I have one problem in enquiry I can catch TODAY DATE and display it in enquiry but it was display as 20160802 so I want to change format it to 02-Aug-2016 and display it as output.

Please help.
Thanks

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

8 years 2 months ago #19857 by VK

Replied by VK on topic Convert from YYYYMMDD to DD-MMM-YYYY in enquiry

Hi
see T24 help for ENQUIRY field CONVERSION.

Cheers
VK

The following user(s) said Thank You: mealea

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

madhulatha
Offline
Junior Member

8 years 2 months ago #19860 by madhulatha

Replied by madhulatha on topic Convert from YYYYMMDD to DD-MMM-YYYY in enquiry

Field Name.9# OPENING.DATE
Operation.9.1# OPENING.DATE
Column.9# 120
Length Mask.9# 11R
Conversion.9.1# ICONV D
Conversion.9.2# OCONV D4-E

by using ICONV and OCONV in the conversion fields.

The following user(s) said Thank You: mealea

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

kripesh
Offline
Platinum Member

8 years 2 months ago #19942 by kripesh

Replied by kripesh on topic Convert from YYYYMMDD to DD-MMM-YYYY in enquiry

Field Name.9 OPENING.DATE
Operation.9.1 OPENING.DATE
Column.9 120
Length Mask.9 11R
Type : D

Just having Type set to D should get you the desired result.

Have a great day !

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

Start
Prev
1
Next
End

Time to create page: 0.077 seconds