Datetime Display - Date Only Or Date And Time

LWSChad · January 9, 2015

Hello All!!

I have a date field in which times are captured and stored some of the time. I am trying to figure out how to display the date in an HTML block in a dynamic way that displays time if present and not if empty.

Please consider:

Date1: 01/06/2015

Date2: 01/07/2015 17:45:00

Desired display:

Date1: Jan 6th, 2015

Date2: Jan 7th, 2015 5:45PM

Actual display

Date1: Jan 6th, 2015 12:00AM

Date2: Jan 7th, 2015 5:45PM

When time is not captured it is not relevant and thus shouldn't be displayed.

I have a workaround that involves a calculated field, but it's pretty clunky.

Any ideas?

Thanks

LWSChad · January 24, 2015

Here is the best answer.

Calculated Field 1

Replace([@dateField],' 12:00AM','')

and

<html>[@calcfield:1]</html>

What a cool parameter -> @calcfield

iren · January 10, 2015

Hi Chad,

If I understand you correctly, you can select 'Forma type: None' in 'Formatting Settings' of 'Field Options' section.

Let me know if it is not what you want.

LWSChad · January 10, 2015

Iren;

Thanks that is closer, but without any formatting the dates are displayed as:

Date1: 01/06/2015

Date2: 01/07/2015 17:45:00

Desired display:

Date1: Jan 6th, 2015

Date2: Jan 7th, 2015 5:45PM

It may seem like a minor difference, but my users will be using this app for hours at a time (some for the majority of a work day), and the former display is harder to read.

FEI (For everyone's information) that calculated field.

Replace([@cbField],' 12:00AM','')

Login

Datetime Display - Date Only Or Date And Time

Question

LWSChad

Link to comment

Share on other sites

3 answers to this question

Recommended Posts

LWSChad

Link to comment

Share on other sites

iren

Link to comment

Share on other sites

LWSChad

Link to comment

Share on other sites

Join the conversation

Browse