YYYYMMDD -> DDMMYYYY field for the web

[sotos]

Hello,

is there any straight forward way from YYYYMMDD to DDMMYYYY field for the web as in "Use Builtin(FINDDATE) With_Args..." ?

best,
Sotiris

[dominique]

Hi Sotiris

Did you try something like this

Define Field(#InputDate) Type(*Dec) Length(8) Decimals(0)
Define Field(#OutputDate) Type(*Dec) Length(8) Decimals(0)

#InputDate := *YYYYMMDD
#OutputDate := #InputDate.AsDate( CCYYMMDD ).AsNumber( DDMMCCYY )


Dominique

[sotos]

Hi,

thanks,

I tried the following and worked:

#Date := #YYYYMMDD.AsString
#DDMMYYYY := (#Date.Substring( 7 2 ) + #Date.Substring( 5 2 ) + #Date.Substring( 1 4 )).AsNumber

but your solution seems much more efficient.

Sotiris

[Dominik]

Hi Sotiris

Just to add to Dominique's response, it is a good idea to make sure that the entered date is a valid one, before executing the AsDate intrinsic function - otherwise you will get a runtime error with that code

If ( #InputDate.IsDate( CCYYMMDDD ) )
#OutputDate := #InputDate.AsDate( CCYYMMDD ).AsNumber( DDMMCCYY )
Else
* Handle the input error
Endif