×
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.TIME formatting in Enquiry
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 7 months ago #22962
by donquixote
DATE.TIME formatting in Enquiry was created by donquixote
Hello, I would like to format DATE.TIME in the following format YYMMDDHHMM±HHMM i.e. 2009041122+0100 with 0100 being the timezone.
Currently it is coming out in this format in ENQ and for some reason a duplicate of the datetime.
Date Time
2002030604
2002030604
Either via a subroutine or using conversion but I have not been able to get either working.
Currently it is coming out in this format in ENQ and for some reason a duplicate of the datetime.
Date Time
2002030604
2002030604
Either via a subroutine or using conversion but I have not been able to get either working.
Please Log in or Create an account to join the conversation.
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 247
- Thank you received: 20
3 years 7 months ago #22967
by silvergem
Replied by silvergem on topic DATE.TIME formatting in Enquiry
You can use the default format from (YYYYMMDD) to DD Mmm YYYY. Just by using the K.TYPE field and adding DATE or DATES. For custom formatting, you can use a subroutine.
On your case, make sure you only return only one value from routine and check the
SINGLE.MULTI field on enquiry
DATE Formats T24 internal date format (YYYYMMDD) to DD Mmm YYYY.
On your case, make sure you only return only one value from routine and check the
SINGLE.MULTI field on enquiry
DATE Formats T24 internal date format (YYYYMMDD) to DD Mmm YYYY.
Please Log in or Create an account to join the conversation.
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 7 months ago #22969
by donquixote
Replied by donquixote on topic DATE.TIME formatting in Enquiry
So what I have is
Single\Multi = S
Field Name = Date Time
Operation = DATE.TIME
Then column\length mask
So not sure why it seems to be giving duplicate date time values as I have selected single, is there a way to force it in the subroutine?
I would like it in the format YYMMDDHHMM±HHMM (With +-HHMM being the current timezone)
Single\Multi = S
Field Name = Date Time
Operation = DATE.TIME
Then column\length mask
So not sure why it seems to be giving duplicate date time values as I have selected single, is there a way to force it in the subroutine?
I would like it in the format YYMMDDHHMM±HHMM (With +-HHMM being the current timezone)
Please Log in or Create an account to join the conversation.
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 247
- Thank you received: 20
3 years 7 months ago #22970
by silvergem
Replied by silvergem on topic DATE.TIME formatting in Enquiry
try to return hardcode valuue. regarding on date fmt you can achieve that using FMT or concatenate the dates
Please Log in or Create an account to join the conversation.
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 7 months ago - 3 years 7 months ago #22971
by donquixote
Replied by donquixote on topic DATE.TIME formatting in Enquiry
Thanks for that, very useful, I have managed to get the date in YYMMDDHHMM format but am struggling to figure out how to add the timezone in +HHMM format i.e. +0000 for GMT etc.
Last edit: 3 years 7 months ago by donquixote.
Please Log in or Create an account to join the conversation.
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 247
- Thank you received: 20
3 years 7 months ago #22972
by silvergem
Replied by silvergem on topic DATE.TIME formatting in Enquiry
concatenate it since it is a variable
Please Log in or Create an account to join the conversation.
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 7 months ago #22973
by donquixote
Replied by donquixote on topic DATE.TIME formatting in Enquiry
The issue is that I can't find +0000, for example, in T24 only in the format like Berlin\Europe
Please Log in or Create an account to join the conversation.
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 247
- Thank you received: 20
3 years 7 months ago #22974
by silvergem
Replied by silvergem on topic DATE.TIME formatting in Enquiry
You can www.wikibanking.info/2013/04/date-time-stamp/ use this as ref. also there is jbc.temenos.com/pages/@timezone.html timezone function. you can file on tcsp related on timezone. after getting that u can concatenate it on your string
Please Log in or Create an account to join the conversation.
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 7 months ago #22976
by donquixote
Replied by donquixote on topic DATE.TIME formatting in Enquiry
Timezone, comes out at Berlin\Europe, is there a way to easily convert to +0000 format, and have it change to +0100 with day light saving.
I have multiple timezones
I have multiple timezones
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
3 years 7 months ago #22978
by VK
Cheers
VK
Replied by VK on topic DATE.TIME formatting in Enquiry
Cheers
VK
Please Log in or Create an account to join the conversation.
Time to create page: 0.136 seconds